When the upgrade to Office was pushed, I got an error with "Method "Method 'Open' of object 'Workbooks' failed" when running the automation within a module, or "The server threw an exception" when run from the debug window. After much angst, troubleshooting, and google searching, it turns out that it was the ApproveIt add-in for Excel So, the moral of the story: if you get either of these errors, check the add-ins.
In retrospect it seems obvious, but since it was related to the push, I was looking at many different things, none of which were previously functional add-ins. Using the ListIndex attribute of the ComboBox does not work - Updating is delayed until my subroutine exits. Which is too late. The code is simple an looks like this: ActiveSheet.
OLEObjects oleobj. I could not find a clue what this is supposed to mean Thanks for your help. Peter Fopma. Sheets "MS Project". OLEObjects 1 y. Verb but how can i de-activate it? Can a variable be used in a Worksheet. Thanks for your feedback. Thanks for your reponse, the first article you talked about is what I have previously gone through and had no success. I modified my registry to unblock silverlight but still received the same error message.
Afterward it told me that it fixed the issue but now the power view add in doesn't seem to exist in my excel. The icon is still in the ribbon but if I click it, it does nothing. I will attach some screenshots of this. In response to your questions, this is the first time I have ever tried to use power view, I am in an excel class that is covering it currently, so I would not know if it worked before.
As you can see in the pictures, the power view add in is not showing up anymore. However, it is strange that using this tool makes the add-in missing. It seems I need to help you fix this issue first. You also can try repairing Office client to see if the add-in comes back. However, serious problems might occur if you modify the registry incorrectly.
Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:. Have you tried repairing the Office or modifying the registry to see if the add-in comes back again?
In the meantime, for the "Activate Method of OLEObject class failed" error issue, I would like to let you know that we will report this issue to our related team, and I'd like to post a summary of the issue here so that other community members can easily see the information. Issue description:. After unblocking Silverlight following support article, Power View is still not working in Excel Additional information:. You are right - the only way to open embedded object in a new instance is to open the entire workbook with macros again which is not what you want.
You can not reference to embedded object without referencing to the main workbook. I would suggest embed the object as link so that you can open embedded object just like regular workbook I edited my post. Thanks Richard. Link will not be useful, since the workbook might change from one computer to another. However I will explore the option of re-opening same workbook.
Just for your information, I finally succeed opening the embedded Excel file in a new Excel instance by 1 opening a new Excel instance, 2 adding a workbook to the new instance, 3 copying the OLEObject to the new workbook and 4 opening the OLEObject from the new workbook.
Following Richard's suggestion, see below the code I built to be able to open an embedded excel object through VBA in a new workbook within a new Excel instance: Dim xlApp As excel. Sheets mySheet. Application xlApp. Add xlWb. Sheets 1. Paste xlWb. Verb xlVerbOpen Regards. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog.
0コメント