View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Karissa Karissa is offline
external usenet poster
 
Posts: 24
Default 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