So it turns out (a month later ) that this doesn't actually work.
I looked it up in the help topics and here's the description it gives:
Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.
I'm not exactly sure what this method is for.
So back to my original question:
What if I don't want to specify the filename and leave it up to the user? I want to point it to a specific folder, but the user can name the file as they see fit.
http://www.excelforum.com/showthread.php?t=576657
-joel
Bookmarks