Error 1004 trying to save active workbook

[littlebob]

I have a macro that runs fine using Excel 2007 on Windows XP, but with Excel 2010 on Windows 7 I get a 'Runtime error 1004' from the following line of code:

ActiveWorkbook.SaveAs Filename:="Teams-" & Range("A2").Value, _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

Am I overlooking something simple?

 

[VoG]

look here http://www.rondebruin.nl/saveas.htm

 

[littlebob]

Perhaps I'm missing something in the above answer, but the failing SaveAs statement does have the FileFormat specified. This isn't a 2003 vs 2010 issue, the code runs on Excel 2007 but not on 2010.

 

[Norie]

Does the filename you are trying to save as have the correct extension?

 

[littlebob]

I guess I'm not posting my problem/question properly. (I'm new at this)
The problem is that a line of code in one of my macros runs fine on my desktop (running XP and Excel 2007) but gives me an error 1004 when I try to run the same macro on a system running Windows 7 with Excel 2010. I guess my question is: Is there a compatibility issue between Excel 2007 and Excel 2010 that would prevent the following line of code to not work? :

Sub prep_update()
'
' prep_update Macro
'
'
(Lots of code between here and the failing instruction, and all work fine.)

(THE FAILING INSTRUCTION FOLLOWS)

ActiveWorkbook.SaveAs Filename:="Teams-" & Range("A2").Value, _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

ActiveWorkbook.Close

End Sub

 

[VoG]

Try adding the file extension

ActiveWorkbook.SaveAs Filename:="Teams-" & Range("A2").Value & ".xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

 

[littlebob]

OK, I feel like a COMPLETE idiot. The error code was telling me what the problem was. There was an invalid character ) in the cell I was using as part of the SaveAs FileName. Of course, that character was not in the cell being used in the macro that worked.
Thanks to all who posted helpful ideas.