Skip to Content
0

EPM Add-in error "Could not load file or assembly 'Microsoft.Vbe.Interop.Forms"

Mar 22, 2017 at 12:23 PM

1.3k

avatar image
Former Member

Hi Team,

We are using BPC 10 Version . We generated the BPC report , we are getting the mentioned below issue

"The type initializer for 'FPMXLClient.ReportManagement.FormattingSheet' threw an exception.
Could not load file or assembly 'Microsoft.Vbe.Interop.Forms, Version=11.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified".

We applied this SAP Note 2403397 . But still issue is not solved

1. In the folder %windir%\assembly\gac or %windir%\assembly\GAC_MSIL there will be a subfolder called :
"Microsoft.Vbe.Interop.Forms"

2. Copy this directory and contents to the affected machine (running Office 2016) - This point i am not cleared . Were we need to paste "Microsoft.Vbe.Interop.Forms" file in the user machine

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Mar 22, 2017 at 12:32 PM
0

Look on the screenshot of my PC:


interop.png (21.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 22, 2017 at 09:04 PM
0

Hi Vadim,
I tried in the affected machine . But I unable get the mentioned below path which you give in the screenshot from your machine

find below screenshot from the affected machine .

C:\\windows\assembly . In under Assembly folder i cant create folder and i cant see GAC_MSIL path

Please suggest


path.png (47.0 kB)
path.png (47.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

You have to provide full details about your windows and Office versions!

0
avatar image
Former Member Mar 23, 2017 at 10:44 AM
0

Hi Vadim ,

We are using Windows 10 and Excel 2016

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Please talk to system administrator... may be you don't have rights...

0
avatar image
Former Member Mar 23, 2017 at 07:00 PM
0

Vadim,

Your saying for this path . We need Admin access to view this path

Please claify

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes, you need admin rights on the local pc!

0
avatar image
Former Member Sep 24, 2017 at 09:29 AM
0

Hi Everyone,

I've been able to get to the directory that Vadim has suggested, not via Windows Explorer but via an elevated command prompt, this has to be done on a machine that has Office 2003, 2010, 2013 though as the directory does not exist on a machine using Office 2016 Click2Run (as per our own set up).

To resolve the issue on our Window 10 Office 2016 Click2Run machines I had to copy the file from a Win7 machine running Office 2010.

Using command prompt do as follows:

cd C:\Windows\assembly\GAC_MSIL\Microsoft.vbe.Interop.Forms\11.0.0.0__71e9bce111e9429c

copy Microsoft.Vbe.Interop.Forms.dll c:\users\you.user (this just need to be any folder except the root of c:\ )

I then took the Microsoft.Vbe.Interop.Forms.dll file and copied it to my windows 10 machine.

On the windows 10 machine I did as follows in a command prompt:

mkdir C:\Windows\assembly\GAC_MSIL\Microsoft.vbe.Interop.Forms\11.0.0.0__71e9bce111e9429c

copy Microsoft.Vbe.Interop.Forms.dll C:\Windows\assembly\GAC_MSIL\Microsoft.vbe.Interop.Forms\11.0.0.0__71e9bce111e9429c

Please note you'll need to cd in command prompt to wherever you copied the .dll file.

I hope this helps.

Ed

Share
10 |10000 characters needed characters left characters exceeded
Marc Kuipers
Sep 25, 2017 at 04:32 PM
0

This was already documented in: https://service.sap.com/sap/support/notes/2403397

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but the note 2403397 was already mentioned in the original post. Looks like the topic author is unable to implement it (no Windows rights).

0

Oops, apologies

0