ExcelBanter - View Single Post - Excel

I hope it continues to work.

wrote:

well, the error popped up again so i did this to "solve" the problem:

I wrote code at the end of the macro to close the file that was just
created, & open it again. then i added a message box to confirm the
success of the new file creation, adding a note to tell the user to
remember to click save. i tried adding the save part into the macro,
but the error kept popping up until you manually clicked save in the
file. only problem here is if the user doesn't click save, but i'm
willing to risk it (this is at least a work-around)...

--

Dave Peterson