Save As error

**jomili** · 03-05-2012, 03:38 PM

Just switched from 2003 to 2010. The following is my tried and true code for 2003:

Please Login or Register  to view this content.

It's failing when I run my macro in a 2010 workbook, saying "Can't Access "Todays Contracts.xls"

Based on Ron's tips here http://www.rondebruin.nl/saveas.htm I tried to change it like this:

Please Login or Register  to view this content.

But this also failed. What am I doing wrong?

**snb** · 03-05-2012, 05:07 PM

Please Login or Register  to view this content.

**jomili** · 03-05-2012, 05:32 PM

Thanks SNB. I assume the rest of my code, following ".fileformat" is correct?

BTW, turns out my code WAS running correctly. The error was due to the fact that someone else had the "Todays Contracts" workbook open, so the macro couldn't save over it.

**snb** · 03-05-2012, 07:02 PM

yes it's correct, but redundant and adding nothing. (check the VBEditor's helpfiles, lemma 'saveas' ... )

**jomili** · 03-06-2012, 09:55 AM

SNB, at first I took exception to your reply, certain that I had no redundant, valueless code. Then I looked at the options coded for, and you're right; in this case the options are redundant, and add no value. That was just some old code I've had for a long time, and copied without analyzing. Thanks for pointing that out.