.XLAM File Appears in Project Explorer in VBE

[Deepak Sharma]

Hi Everyone,

I have added a add-in file in addin folder for some functions. Every function is working fine but this file is showing in Project Explorer in VBE Window.
I want that every function should work as it is but this file should not show in VBE Window. When I right click on this file & try to remove, this option shows disable.

Is there any option to remove it from VBE but not from Add-ins.

Thanks and Regards,
Deepak Sharma

 

[Chihiro]

Nope there isn't for xlam addin.

You could... build COM addin, xll addin (written using C#, VB .NET etc), and those won't show in VBE, but then that's a lot more work

 

[Deepak Sharma]

Hi Chihiro, Thank You for you reply!

Can you please brief me on these two things or any articles or step by step guide link for point no. 2

1. What is "ExcelDna.IntelliSense" ?

2. How to create ribbon which should be visible for other use also If I send them that file in which I have recorded some macro and assigned to customize ribbon button ?

Regards,

 

[Chihiro]

1. ExcelDna is open source project to integrate .NET into Excel.
From their website...

Excel-DNA is an independent project to integrate .NET into Excel. With Excel-DNA you can make native (.xll) add-ins for Excel using C#, Visual Basic.NET or F#, providing high-performance user-defined functions (UDFs), custom ribbon interfaces and more. Your entire add-in can be packed into a single .xll file requiring no installation or registration.

ExcelDNA.Intellisense is project that add in-sheet Intellisense for Excel UDFs.
https://github.com/Excel-DNA/IntelliSense

2. Have a read of Ron De Bruin's site. It's one of best resource for Custom Ribbon/QAT.
https://www.rondebruin.nl/win/section2.htm

 

[Deepak Sharma]

Oksss... Thanksss alot for your help !!

Regards,
Deepak Sharma