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")
Reply With Quote