Excel Macro to print pdf file to location based on cell value and file name based on cell value
This is the VBA that works, saves the file names based on cell ("Q24") value, but will not place the file to the correct folder, Cell "Q25" has a formula =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)&"Purchase Orders" which gives me the path Z:\07 ARCHIVE FILES\0000 NEW CLIENT\Purchase Orders
It will not save in this Folder???
Sub SaveSheetsAsPDF()
'Create and assign variables Dim saveLocation As String saveLocation = Range("Q25").Text
'Save Active Sheet(s) as PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=Range("Q24").Value, OpenAfterPublish:=True
End Sub
Can someone help with this
This is the VBA that works, saves the file names based on cell ("Q24") value, but will not place the file to the correct folder, Cell "Q25" has a formula =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)&"Purchase Orders" which gives me the path Z:\07 ARCHIVE FILES\0000 NEW CLIENT\Purchase Orders
It will not save in this Folder???
Sub SaveSheetsAsPDF()
'Create and assign variables Dim saveLocation As String saveLocation = Range("Q25").Text
'Save Active Sheet(s) as PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=Range("Q24").Value, OpenAfterPublish:=True
End Sub
Can someone help with this
