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")
Here is my code for the save as. Does anyone see anything out of the ordinary?
ActiveWorkbook.SaveAs ("H:\FINAID\" & myFileName & ".xlsx")