Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Macro
I have a button attached to a macro which saves the
workbook to its current location and back to the server. ActiveWorkbook.Save ActiveWorkbook.SaveAs (ServerName) The problem appears to be with saving to the current location. It sometimes looks as if it is saving and the modified date and time property seems to support this but the changes are not saved! I have changed this to a saveAs option so that i get the confirm overwrite message. Sometimes it appears and other time not. Do I have a problem with my macro or is there a system/windows problem? Any suggestions please, thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Macro
Once you do the saveAs to the server, then if you ran this again, you would
just be saving to the server. This might be related to your problem. Perhaps you want to use SaveCopyAs to the server so you don't change the workbook you are working with. -- Regards, Tom Ogilvy "judith" wrote in message ... I have a button attached to a macro which saves the workbook to its current location and back to the server. ActiveWorkbook.Save ActiveWorkbook.SaveAs (ServerName) The problem appears to be with saving to the current location. It sometimes looks as if it is saving and the modified date and time property seems to support this but the changes are not saved! I have changed this to a saveAs option so that i get the confirm overwrite message. Sometimes it appears and other time not. Do I have a problem with my macro or is there a system/windows problem? Any suggestions please, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Please help macro for save | Excel Worksheet Functions | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
Macro-Save as | Excel Discussion (Misc queries) | |||
Prompted to save changes after macro save - why? | Excel Programming |