| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As help
I have a macro assigned to a button. With this macro, I
want to bring up the "Save As" dialog box just as if the user was to go to File Save As. Is there a way to do this? Thanks, Brad E. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As help
Hi
have a look at the GetSaveAsFilename method in the VBA help -- Regards Frank Kabel Frankfurt, Germany Brad E wrote: I have a macro assigned to a button. With this macro, I want to bring up the "Save As" dialog box just as if the user was to go to File Save As. Is there a way to do this? Thanks, Brad E. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As help
you could assign the code
Savefile = Application.GetSaveAsFilename ActiveWorkbook.SaveAs Savefile HTH Davi -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save As help
Hi,
FileName = Application.GetSaveAsFilename ActiveWorkbook.SaveAs FileName Paul "Brad E" wrote in message ... I have a macro assigned to a button. With this macro, I want to bring up the "Save As" dialog box just as if the user was to go to File Save As. Is there a way to do this? Thanks, Brad E. |
| 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) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Linear Mode
