I use this code to save sheets as a .PDF with the sheet tab and year as the file name which works fine.
I would like it to point to a specific folder so the user doesn't have to choose a location on his/her own.
I tried something like: ChDir "C:\Documents\Supplies" but cannot make it work. Still opens a general save dialog box.
Any ideas? All help is appreciated........
Please Login or Register to view this content.
Bookmarks