Macro Suddenly starts giving error

[wouldbeca]

Hi All,

I am using a macro for last one and half year for creating a report to be sent to the user, but suddenly from yesterday, it started giving me error " File Not Found 'C:Users\31946450\AppData\Local\Temp\VBCE74.tmp . I had not changed anything in the configuration of the system or excel either. Not able to understand reasons for this error as I am using this file for a quite a while now.

Exact place where error is coming:-

selsheet.Activate
Sheets("Summary").Select
Sheets("Summary").Copy After:=Workbooks(Aname & ".xlsx").Sheets("Sheet1")

There are 6 files which are being copied like this. and error comes or not comes at any fixed file comes come randomly in some of them. In case I debug, it continues in a single click or multiple clicks but creates a blank file in that sheet.
Any help is really appreciable

 

[mole999]

have you cleared out your temp folders / wastebin and restarted

any updates done recently

how many pages in that workbook currently

 

[wouldbeca]

1. I cleared temp but the problem remained.

2. No update. it worked perfectly well the day before yesterday. Yesterday, the error came once, I restarted excel and it worked well afterwards. But today it failed to work.

3. By pages you meant sheets?..Total of 12 sheets in the master workbook. Out of which, 6 sheets ( 3 of them having data tables, move to a new workbook.

have you cleared out your temp folders/wastebin and restarted

any updates done recently

how many pages in that workbook currently

 

[mole999]

Is there a sheet1, whereas sheet(1) might be better ?. There must be loads of reasons, these would be my first looks

 

[wouldbeca]

Happy new year...Thanks for the help but not really helpful. As I said earlier, the code was working fine for last 1 and half year and suddenly it started giving the problem. So I don't think the problem would be much with code. it needs to be something else.

Is there a sheet1, whereas sheet(1) might be better ?. There must be loads of reasons, these would be my first looks

 

[mole999]

one final thought, you are not opening a copy in outlook are you?, this is a file that resides in the desktop or else

 

[wouldbeca]

File resides in D Drive in PC.

one final thought, you are not opening a copy in outlook are you?, this is a file that resides in the desktop or else