Run-time error '1004' on closing workbook

[pipoliveira]

Dear all,

I hope you are all well.

I am having the following error:

Run-time error '1004'
Select method of Range class failed

This error is on the Workbook.Close event in red:

Please Login or Register  to view this content.

This code copy information from a "Child" document to a "Master".

I have a similar Master file with the exact codes (from other files) and it works perfectly closing the "Child" files without any errors.

Any ideas why on this code it gives me the error?

Your assistance will be highly appreciated.

Best regards,
Filipe Oliveira

[HerryMarkowitz]

If you want to close wbAnalytics workbook you should use following code;

Please Login or Register  to view this content.

If you dont want to close wbAnalytics workbook you dont need any code. So, you can delete that line.

[pipoliveira]

Hi Herry,
Thanks for the reply.
Your code is to close and save but I just want to close it without saving, that's why my code has "False".
As mentioned, the same code works perfectly on other similar file but on this one I get that error code.
Cheers,
Filipe


Sent from my iPhone using Tapatalk

[HerryMarkowitz]

According the code you sent there is no changes workbook declaring wbAnalytics (C:\Users\PIPO\Documents\Analytics_DashBoard.xlsm).
So, you dont need without saving thing.

Do you want time saving?

[pipoliveira]

Hi Henry,
Thanks for the reply.
Even without changes, I have VBA codes on the "Open" and "before closes" events, meaning, only opening that file and closing, Excel asks if I was to save the changes.
The main issue here is the "run-time error" that I am trying to understand why he does not accept it.
I even tried your code and the same error occurred.
Best regards,
Filipe


Sent from my iPhone using Tapatalk

[HerryMarkowitz]

Change this,

Please Login or Register  to view this content.

to this,

Please Login or Register  to view this content.

or,

Please Login or Register  to view this content.

[pipoliveira]

Hi Herry,
Thanks for your reply and efforts.
Unfortunately, I have the same errors again with your codes.
There must be something giving that error as I have the same one (Different workbooks) and it works fine.
Best regards,
Filipe

[romperstomper]

You haven't posted the code in the BeforeClose event of that file. However, since you're not saving it, there doesn't seem to be a lot of need to run any code in it, so perhaps you could just use:

Please Login or Register  to view this content.

[pipoliveira]

Hi romperstomper,

You really hit the spot with the "Application.EnableEvents".

Still don't understand what "events" were creating the Error but it solved it.

Thanks a million once again.

Really appreciated.

Best regards,
Filipe

[HerryMarkowitz]

Dont forget sending us a reputation point.