When I run this it saves to the Location that's in cell Z2 but saved it with filename as FALSE, any ideas what's wrong with my code ???
In cell Z2 it has location with filename at the end which will show current date "C:\Users\me\Documents\File Name 19-01-23.pdf"
Please Login or Register to view this content.
Last edited by davesexcel; 01-19-2023 at 03:58 PM. Reason: code tags required for vba code
What is in Z2 exactly.
Re: VBA to save to location and filename in a Cell
Just remove saveLocation = which has no sense after Filename = ‼
Cell z2 contains the location I want the PDF saving to. So it’s the file location & file name including date and timeOriginally Posted by davesexcel
I revised as suggested (see below ) and it wouldn’t Run
Just remove saveLocation = which has no sense after Filename = ‼
Sub Create_Shift_PDF()
'
' Create_Shift_PDF Macro
' Will Save Current Data as a PDF Form
'
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ Sheets("Shift Brief").Range("z2").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub
I believe he wanted to know exactly what's in the cell, not a description of it.
Your problem may lie in the date or time portion of what's in the cell.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Re: VBA to save to location and filename in a Cell
According to post #5 you forgot to remove the underscore after Filename …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks