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.
Thanks
Please Login or Register to view this content.
Erick
Does it help if you use:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
unfortunately it does not, same error using the number codes
Curious - it just worked for me in a quick test.
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
Late binding - I assume you were early binding, or your code shouldn't ever work.
You might try:
first?Please Login or Register to view this content.
well that is interesting, I believe I am using late binding as seen in the original post. I put in the
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.Please Login or Register to view this content.
At least the calculation line completed.
If you were late binding originally, then xlCalculationAutomatic and xlCalculationManual would have had no values (as they are constants from the Excel object library, which you hadn't referenced, or declared anywhere that I can see) so those lines should never have worked (unless you had an error handler suppressing that).
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?
If you have the reference set, you don't need to declare them (nor is there any real point in late binding!)
Ok I tried this vanilla code and get the same error. Can you replicate it?
Thanks for your help on this.Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks