I have a file-name-save macro that appends concatenated, record-specific data located in cell H60 to the file name
Public Sub SAVE_WORKBOOK()
ThisFile = Range("SDC!H60").Value
ActiveWorkbook.SaveAs filename:="C:\POSE DATA 2006-7\" & ThisFile & ".xlsm", FileFormat:=52
End Sub
This works fine in XP/Excel 2003, XP/Excel 2010, Windows 7/Excel 2010.
I am able to successfully change the target file on an XP/Excel 2010 computer as follows:
Public Sub SAVE_WORKBOOK()
ThisFile = Range("SDC!H60").Value
ActiveWorkbook.SaveAs filename:="C:\POSE DATA 2011\" & ThisFile & ".xlsm", FileFormat:=52
End Sub
Applying the exact same macro to a Windows 7/Excel 2010 computer, I get the following error message:
"Microsoft Excel cannot access the file : 'C:\POSE DATA 2011\5DEDC330' ."
It seems as if the fileformat:=52 switch is not recognized.
Was gibt??
Public Sub SAVE_WORKBOOK()
ThisFile = Range("SDC!H60").Value
ActiveWorkbook.SaveAs filename:="C:\POSE DATA 2006-7\" & ThisFile & ".xlsm", FileFormat:=52
End Sub
This works fine in XP/Excel 2003, XP/Excel 2010, Windows 7/Excel 2010.
I am able to successfully change the target file on an XP/Excel 2010 computer as follows:
Public Sub SAVE_WORKBOOK()
ThisFile = Range("SDC!H60").Value
ActiveWorkbook.SaveAs filename:="C:\POSE DATA 2011\" & ThisFile & ".xlsm", FileFormat:=52
End Sub
Applying the exact same macro to a Windows 7/Excel 2010 computer, I get the following error message:
"Microsoft Excel cannot access the file : 'C:\POSE DATA 2011\5DEDC330' ."
It seems as if the fileformat:=52 switch is not recognized.
Was gibt??