Thread: [Solved] Insert variable in path name
View Single Post
 
Old 01-03-2019, 08:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,382
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by bearcublandon View Post
I like that , what does this statement do - with the showing of the dialog?
Well, with the dialogue open, you can insert the filename of your choice, then click OK to save.
Quote:
Originally Posted by bearcublandon View Post
By the way, every time I save a file Microsoft Ege keeps popping up trying to display the PDF document (which never happens, the new tab always remains blank).
That's because your code (which I replicated) has:
OpenAfterExport:=True
If you set that to False, Edge won't keep popping up trying to display it. Evidently there's some communication problem with Edge if all you're getting is a blank page.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote