Run-time error '1004' with ActiveWorkbook.Save

S

SteveC

My code works fine until it hits the command ActiveWorkbook.Save. That's
when I get teh error:

Run-time error '1004': Methond 'Save' of object '_Workbook' failed

This code was working fine, but now all of a suddent doesn't work fine in
Excel 2007.

Any suggestions? thanks very much.
 
J

JLGWhiz

I think it has something to do with the file extensions. I have not used
xl2007 but it seems like I saw a similar posting before and it had to do with
the new 4 digit extension and one being for files with macros vs files
without macros.
 

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

Save failing 2
"Run-time error '1004' 5
Run-time error when copying entire row! 5
Run time error 2
trying to email workbook from VB6, getting error 1004 2
Application.top=0 fails 3
runtime error code 1004 2
Problems with a Run-time error of 1004.... 7

Top