Hi, the code im using works in excell 2007 but when i switch to 2010 it gives me the error message "Microsoft Excel cannot access the file c:\temp\. the lines where the error is occuring is the following:
ActiveWorkbook.SaveAs Filename:= _
"C:\Temp\" & ThisWorkbook.Worksheets("emailnames").Range("team_name") & " CDM Action List.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
can you tell me why this is happening. Im guessing its a change in syntax between 2007 and 2010.
Bookmarks