| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SaveAs in Macro
I am trying to add a 'SaveAs' to a macro so the user must save the
workbook under a different name. I have tried "Application.getsaveasfilename", "workbook.saveas", "activeworkbook.saveas". These are not working. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SaveAs in Macro
This will propt user to save as
Application.Dialogs(xlDialogSaveAs).Show "gfkbob" wrote: I am trying to add a 'SaveAs' to a macro so the user must save the workbook under a different name. I have tried "Application.getsaveasfilename", "workbook.saveas", "activeworkbook.saveas". These are not working. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SaveAs in Macro
well, it is important to know if you're using xp or 2003 excel...
"gfkbob" wrote in message ups.com... I am trying to add a 'SaveAs' to a macro so the user must save the workbook under a different name. I have tried "Application.getsaveasfilename", "workbook.saveas", "activeworkbook.saveas". These are not working. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing SaveAs to new name | Excel Discussion (Misc queries) | |||
| SaveAs | Excel Worksheet Functions | |||
| SaveAs dialog | Excel Discussion (Misc queries) | |||
| SaveAS macro Query | Excel Discussion (Misc queries) | |||
| Saveas Macro | Excel Discussion (Misc queries) | |||
![gfkbob[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
