Question

Q: 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

Answer

A:

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.



 
Question Info

Views: 583 Last updated: February 27, 2018 Applies to: