Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
VBA script error in GetObject function in Excel 365
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 78%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mano Johnson
5
Reputation points
I am trying to call wcf service moniker string in GetObject function in vba macro script in Excel 365 , but the getting the following error. It was working fine with previous versions of excel.
Runtime error '-2147221020 (800401e4)
Automation error
Invalid syntax
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
-
Mano Johnson 5 Reputation points
2023-06-23T04:33:09.68+00:00 Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20676) 64-bit
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 43%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUA%3C/text%3E%3C/svg%3E)
Uwe Admiral 0 Reputation points2024-05-05T20:53:56.9166667+00:00 Hi Mano
have you found a solution in the meantime? I would be very grateful for a hint.
Many greetings
Uwe
-
Mano Johnson 5 Reputation points
2024-05-12T13:10:38.1066667+00:00 Moved wcf service moniker logic to vbs script and called the vbs from excel macro
Sign in to comment
Sign in to answer