| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As in VBA
I want to put a Save AS button on a worksheet that will open the Windows SaveAs dialog box so the user can select the path to where he wants the worksheet saved. An inputbox will ask for the new file name prior to opening the SaveAs dialog box. Bill *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As in VBA
You might be able to modify the "Save Changes?" example on my web site.
-- Rob van Gelder - http://www.vangelder.co.nz/excel "Bill D." wrote in message ... I want to put a Save AS button on a worksheet that will open the Windows SaveAs dialog box so the user can select the path to where he wants the worksheet saved. An inputbox will ask for the new file name prior to opening the SaveAs dialog box. Bill *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As in VBA
Thanks Rob for the help and another great resource to add to my list. I have been using the GetSaveAsFilename but so far the file is never actually saved. I know I'm doing something wrong but your reply at least tells me I am using hte correct command. Thanks Bill *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As in VBA
I have used the same approach to saving. However, the file actually doe
save, just not with the name I specified. I noticed the name I pas into the GetSaveAsFileName method appears in quotes, I do not know i this is something I need to change. Any ideas -- Message posted from http://www.ExcelForum.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As in VBA
It something you are using now doesn't work or doesn't work as expected,
then change is definitely an option. -- Regards, Tom Ogilvy "Ripan " wrote in message ... I have used the same approach to saving. However, the file actually does save, just not with the name I specified. I noticed the name I pass into the GetSaveAsFileName method appears in quotes, I do not know if this is something I need to change. Any ideas? --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
Linear Mode
