View Single Post
 
Old 07-16-2014, 07:11 AM
WeDonNeedNoSteenkgRibbons's Avatar
WeDonNeedNoSteenkgRibbons WeDonNeedNoSteenkgRibbons is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2014
Posts: 23
WeDonNeedNoSteenkgRibbons is on a distinguished road
Default

Does this sound right?

- .FileDialog to (pre)specify folder
- .SaveAs to (pre)specify filename
- .getsaveasfilename to (pre)specify neither

By the way, Bob, and you probably also know this well - the file dialog has more bonus utility available. As it's closely related to or integrated with Explorer or folder displays, you can do many of the same things. Thus when in Excel (which is 100% of the time for some of us, right?), if you don't feel like opening a folder, just go alt-F/O or alt-F/A and e.g. delete or open files from there, including nonExcel ones. Often the current dir in Excel is already sitting on a location where you're doing other file operations on a project, so it's a little timesaver.
Reply With Quote