I'm trying to have a macro that opens the save as window, places the name in cell f5 and then allows you to save the workbook with cell f5 as the filename. I have managed to get the save as window to come up and the cell f5 as the name, but when I press save is doesn't. Here is what I have (also, is there a way to direct this to a specific folder).
Please Login or Register to view this content.
Last edited by beatnik; 10-25-2008 at 10:29 PM.
This will just do a Save As and use the what ever is in Cell (F5)+.xls.Please Login or Register to view this content.
double post
Last edited by Slomaro2000; 10-22-2008 at 01:48 PM.
GetSaveAsFilename doesn't actually save the file; it just gets the name -- you have to save it yourself.
If the user clicks Cancel, it returns False to a Variant or "False" to a string.
Entia non sunt multiplicanda sine necessitate
Well, I managed to get what I needed figured out. Just not the defined folder part.
Edit update: The tools/options/general tab has the default file location there, I'm complete now.
Please Login or Register to view this content.
Last edited by beatnik; 10-25-2008 at 10:29 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks