Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 22, 2017 at 12:32 PM

    Look on the screenshot of my PC:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 09:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    Hi Vadim ,

    We are using Windows 10 and Excel 2016

    Add comment
    10|10000 characters needed characters exceeded

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

    Vadim,

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

    Please claify

    Add comment
    10|10000 characters needed characters exceeded

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 25, 2017 at 04:32 PM

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

    Add comment
    10|10000 characters needed characters exceeded