Stuck on the coding issue for this problem. I am trying to have my excel file automatically save as a pdf file with a time stamp. EX filename.ddmmyy pdf. Any ideas on where i messed up the syntax. Not sure if it is the file path or something else that I may have screwed up.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Range("S5").Value, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
its probably the format of the timestamp as default uses "/" as date seperators which cannot be used when saving files
quick fix would be
Filename:=replace(Range("S5").Value,"/","-")
if you are using time as well then you will need to repeat this with ":" which also cannot be used to name files
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks