on 07-28-2014 1:48 PM
Hello,
I would like to use Universe Design Tool COM SDK in Powershell (instead of Excel and VBA). I was trying to import Designer.dll in Powershell but getting error:
PS C:\Windows\system32> [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\Designer.dll")
Exception calling "LoadFrom" with "1" argument(s): "Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\Designer.dll' or one of its dependencies. The module was expected to contain an assembly manifest."
At line:1 char:1
+ [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\SAP BusinessObjects\SAP ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : BadImageFormatException
Any idea is it possible and how to use Designer.dll from Powershell?
Many thanks and regards
Try referencing Designer.exe instead of Designer.dll.
Thanks,
Bhushan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I was trying that already, unfortunately the same issue:
PS C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86> [Reflection.Assembly]::Lo
adFrom("C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\designer.exe")
Exception calling "LoadFrom" with "1" argument(s): "Could not load file or assembly 'file:///C:\Program Files (x86)\SAP
BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\designer.exe' or one of its dependencies. The module w
as expected to contain an assembly manifest."
At line:1 char:1
+ [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\SAP BusinessObjects\SAP ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : BadImageFormatException
You mean if I can using Designer Libraries in Excel? Yes, when I go to Excel > Visual Basic editor, then when I'm checking References there is already reference to Business Object Designer 14.0 Object Library, I need just to check it for make it available in script.
How does it work Excel knows already there is such library and is able to use it but Powershell doesn't? If I understand idea of those COM things it should work in any compatible environment because should be managed and delivered to Excel, Powershell, ... by OS? (sorry, I'm rather linux guy, just using windows in work )
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.