ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro crashes "Automation error" during copy of workbook with char (https://www.excelbanter.com/excel-programming/351852-macro-crashes-automation-error-during-copy-workbook-char.html)

Yorch

Macro crashes "Automation error" during copy of workbook with char
 
When I run a macro, I try to copy an entire excel book and then, in the new
workbook I delete the worksheets I dont need.

I receive the message "Error in automation 21474178481(80010108)" and
closes the excel program. I think the problem is that some sheets have
charts.

The argument with the problem is:

Worksheets.copy here it crashes

If I run the macro in the vb debug view, it can copy the workbook without
problem. But after 3 or 4 runnings it crashes.

I have tried some other commands such as:
Dim SH As Worksheet
Set SH = Worksheets.copy

but it does not work. Any idea?


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com