set calculation property in embedded excel object

I am trying to set the application.calculation property in an embedded excel workbook object in a powerpoint file using a powerpoint vba macro. With the code below I am receiving the error:

'Unable to set the Calculation property of the Application class'

This would really help performance if I can get this to work.

Please Login or Register  to view this content.

Thanks

Erick

unfortunately it does not, same error using the number codes

I would believe it, this has worked once or twice, but it will not work consistently. I believe it has something to do with recognizing the Excel application object from the embedded object.

In other posts that I have read, they mention a workbook needs to be active. I tried oxlbook.Activate, but it did not make a difference. The rest of the code works fine for accessing and manipulating the Excel workbook object.

Did you use early or late binding?

Erick

well that is interesting, I believe I am using late binding as seen in the original post. I put in the

Please Login or Register  to view this content.

and that broke the line in the 'For Each' statement with an application-defined or object-defined error and has the object opened.

Please Login or Register  to view this content.

This has always run without needing to open the individual objects.

At least the calculation line completed.

ok, that is good to know.

I have the Excel 11.0 Object Library checked in the references of my VB editor. How do I declare the values?

Ok I tried this vanilla code and get the same error. Can you replicate it?

Please Login or Register  to view this content.

Thanks for your help on this.

ok, some developments.

Using the vanilla code in my previous post, I can make it work IF:

I have excel open with any spreadsheet open (even unsaved blank). Then insert an excel object on to the ppt slide.

If you then close excel or just close the open spreadsheet, it will not work.

I was running the code usually with Excel closed are empty (without a spreadsheet).

At least now I have a work around, will continue to work on it.