I am using Application.GetSaveAsFilename to get a file name input by the user. I am trying to set both the opening folder path as well as a suggested file name using the InitialName parameter. If I specify InitialName as the full path and file name, it opens in the C:\ root directory. If I specify just the file name without the path, it opens in the same directory as the workbook file. Is there any way to set both the opening path and the file name separately?
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Hi Joe,
Instead of Application.GetSaveAsFilename why not try to use
which will open a dialog box and allow the user to select the file they want.Please Login or Register to view this content.
Then you can parse the path and file returned name.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi,
I would just add to shg's answer to say that it is safer to use ChDrive first to ensure the correct drive is current, otherwise the ChDir may not work even though it won't cause an error.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks...I'll try the proposed solutions. I did not think you could change the directory in Excel VBA, only read the current directory. Also was not aware of the Application.FindFile function.
The ChDrive and ChDir worked great. The Application.FindFile is only for opening files and does not return a file name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks