Windows XP, Excel 2010......my big macro was working fine and all of a sudden didn't.
In the earlier part of the macro I open a new file and saveas with a new filename. then I import some smaller sheets into it, (4-5 or so) and massage them a bit and then resave the file with
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=Consolidator & SelectedQuotenumber & ".xlsm"
Application.DisplayAlerts = True
It was working fine for some time and now breaks on the second SaveAs line with the error message "Run time error 1004, Cannot access Consolidator131.xlsm.....which is the result of "consolidator & selectedQuoteNumber"
Don't know why it quit working, nor how to fix.........any ideas would be much appreciated.
Vaya con Dios,