Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Document not saved at the end of macro
Hi All,
I've written code to delete unnecessary modules and copying a module content into 'Thisworkbook'. Upto here its working fine and end of the macro I've written Thisworkbook.save. While executing save statement I'm getting an error saying 'Document not saved'. I'm clicking on 'Ok' button and I'm able to save manually. Is there any workaround to save document? Advanced Thanks, Vinod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Document not saved at the end of macro
Try using the term "activedocument" instead of "thisworkbook".
"Vinod" wrote: Hi All, I've written code to delete unnecessary modules and copying a module content into 'Thisworkbook'. Upto here its working fine and end of the macro I've written Thisworkbook.save. While executing save statement I'm getting an error saying 'Document not saved'. I'm clicking on 'Ok' button and I'm able to save manually. Is there any workaround to save document? Advanced Thanks, Vinod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
document not saved | Excel Worksheet Functions | |||
Document Not Saved | Excel Discussion (Misc queries) | |||
Document not saved | Excel Discussion (Misc queries) | |||
Document not saved | Excel Discussion (Misc queries) | |||
DOCUMENT NOT SAVED | Excel Discussion (Misc queries) |