Run time error 1004, Cannot access file

Hi All.......

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,

Chuck, CABGx3

 

Question Info


Last updated February 27, 2018 Views 665 Applies to:
Answer

OK Guys, crisis is over......dunno why, but I reworte the whole macro and all is fine now.  Must have been some kind of invisible bug...lol

Vaya con Dios,

Chuck, CABGx3

=SUM(091938,USMCe4,WACS'61,USPatD248465, DADx3,CABGx3+AAA,MMOUS2k,VBAxlDev,MCC2011)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.