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

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