On Windows 7 desktop, getting a Run-time error 1004: Method 'SaveAs' of object_Workbook failed on an Excel macro that worked in XP. The highlighted code where it halts is:
ActiveWorkbook.SaveAs Filename:=_
"G:\Fixed Income\Credit Daily Reports\Short Duration\" & rptdate & "_ShortDurationSector.xlsx",_
File Format:=xlOpenXMLWorkbook, Password:="", WriteResPassword:="", ReadOnlyRecommend:=_
False, CreateBackup:=False
Any ideas why this would not work in Windows 7?
Bookmarks