PDA

View Full Version : Exel File Corrupt when opening



mklindquist
10-22-2013, 12:19 PM
When I save an excel file using a macro and try to open up later it says my file is corrupt. But if I save a file without the SaveAs in the macro it opens up normal.

Here is my code for the save as. Does anyone see anything out of the ordinary?
ActiveWorkbook.SaveAs ("H:\FINAID\" & myFileName & ".xlsx")

streub
10-22-2013, 02:01 PM
Try

ActiveWorkbook.SaveAs ("H:\FINAID\" & myFileName & ".xlsm")