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

Run Time Error 1004 Copy method of Worksheet class failed 2
Problems with appilcation.filesearch 1
Excel - Marco error .......HELP 4
Programming IDE 1
Run time error '1004' 5
Cannot send out Excel workbook through Outlook Express 9
Run-time error '1004' 1
SumIF error 1004 4

Top