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.

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.

"SteveC" wrote:

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.

See this page Steve
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SteveC" wrote in message ...
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.