The type 'VBE' is defined in an assembly that is not referenced. You must add a reference to assmblt 'Microdoft.Vbe.Interop'...

Eduards Gzibovskis 1

I keep getting this error above.

I then Tried adding this top reference (See image below).

But this not solve the error.

How do I fix the issue?

Thanks,
Ed

Hui Liu-MSFT 48,571 Reputation points Microsoft Vendor

2021-09-03T02:57:17.247+00:00

Hi,@ EduardsGzibovskis-2327. Could you show me your complete code to analyze and reproduce the problem?

Eduards Gzibovskis 1

Hi,

This works on .NET Framework but not on .NET 5.0

Also, I realised the following:

.NET Framework:

VBE shows up

.NET 5.0:

VBE does not show up

See below example:

using Excel = Microsoft.Office.Interop.Excel;  
  
// Load Excel sheet  
var excelApp = new Excel.Application();  
Excel.Workbooks books = excelApp.Workbooks;  
Excel._Workbook sheet = books.Open("path to Excel");  
  
// Load macro to excel  
excelApp.VBE .ActiveVBProject.VBComponents.Item("Sheet1").CodeModule.AddFromFile(@"G:\Templates\VBA.txt");  
  
// Show the file  
excelApp.Visible = true;  
  
// Run the internal Macro  
excelApp.Application.Run("Sheet1.merg");

Hui Liu-MSFT 48,571 Reputation points Microsoft Vendor

2021-09-09T07:51:54.74+00:00

Hi,@ EduardsGzibovskis-2327. May I know if you have got any chance to check my answer? I am glad to help if you have any others questions.
Eduards Gzibovskis 1 Reputation point

2021-09-09T07:53:48.64+00:00

Hi,

Thanks for your answer.

I have not tried it out. But I managed to solve it, see my answer https://stackoverflow.com/questions/69041680/microsoft-vbe-reference-in-net-5-0-not-available

Thanks,
Eduards

1 answer

Hui Liu-MSFT 48,571 Reputation points Microsoft Vendor

2021-09-07T03:13:19.173+00:00

The error shows that Microdoft.Vbe.Interop is missing. So I tried to add ExcelDna.Interop, which contains Microdoft.Vbe.Interop. You could try to see if it matches your program.

And then the error disappeared.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][3] to enable e-mail notifications if you want to receive the related email notification for this thread.

[3]: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

The type 'VBE' is defined in an assembly that is not referenced. You must add a reference to assmblt 'Microdoft.Vbe.Interop'...

1 answer

Your answer