Insert variable in path name

macropod · #6 01-03-2019, 08:14 PM

Quote:

Originally Posted by bearcublandon

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

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to Insert variable rows based on a data in active cell	Marcia	Excel Programming	4	07-28-2018 10:02 AM
Insert a Variable Row to SUM SubTotal	ChrisOK	Excel Programming	3	02-12-2018 10:46 AM
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
insert auto path & file name in ppt 2013	rideninc	PowerPoint	1	01-28-2014 05:38 AM