Document not saved at the end of macro

V

Vinod

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro saved .xls file is not opening in 2007 2
Run macro at open 2
document not saved 1
Why does the macro I created to Recheck Spelling not work? 1
Executing a macro/script whenevera document is saved 0
Excel 2003 - VBA to get a list of Module names in the project 4
Unwanted at end of document 2
I can't remember the name of a saved document but I do remember s. 3

Top