1004: close method of workbook class failed

[desmike481]

I have a set of Excel macros that create powerpoint slides. They were working fine until this month... The issue is when I try to close the chart worksheet after creating a chart.

This simple procedure reproduces the issue. As I said above, this wasn't an issue a month back. I've created dozen of presentations, so something may have changed with Excel. I'm using MSO Home and Student 2016 (16.0.12624.20422) 32-bit.

Please Login or Register  to view this content.

[5631]

It's probably a conflict of some names.

[desmike481]

There's no conflict I can detect. And this was working code not long ago. I can't seem to close a chart worksheet via VBA once it's opened by creating a powerpoint chart.

[Trebor76]

Hi desmike481,

Welcome to the forum!!

If the "myChartData" variable is correctly assigned to an Excel workbook, to close it (without saving) the command is this:

Please Login or Register  to view this content.

I'm not sure with your code though as "myChartData" seems to be both PowerPoint and Excel related

Robert

[desmike481]

Apologies I was unclear. I run a set of macros in Excel which create powerpoint presentations with the data from an Excel workbook. The test code I've copied here reproduces the issue I am having. I replaced my close with the one you provided and receive the same error.

Please Login or Register  to view this content.

[Trebor76]

Same issue - this won't work as "myChartData" has been assigned to a PowerPoint object but the following is an Excel only command:

Please Login or Register  to view this content.

I'm not sure how it ever worked to be honest

See how this goes:

Please Login or Register  to view this content.

Note also that you cannot "close" an Excel tab so the last line of code closes the entire workbook (though not sure why you'd close it straight after pasting data in without seemingly doing anything else).

Regards,

Robert