How To Programmatically Add Library References Using VBA 

That was great work., the only issue is that we still need to manually add the "Visual Basic For Applications" reference!

I have a error message for line "Set vbProj = ThisWorkbook.VBProject" Error message is method 'vbproject' of object '_workbook' failed How can I fix it? Thanks for your help.

Hi @Sigma Coding, Thanks for taking the time to put together such a good video. To be able to programmatically add references the "Microsoft Visual Basic for Applications Extensibility" reference/library has to be enabled. How do you enable this reference/library without asking the user to do it manually? Also, the "Trust access to the VBA project object model" option in the "Trust Center Settings" has to be enabled as well. How do you get around this without asking the user to do it manually? Thanks,

Thanks I was searching for the same

Thanks for the great code. Just for your information there are may references with a type of 0 rather than 1. For example, the Solver add-in that come with Excel and the VBIDE have types of 0. I am not sure what makes the difference however. +

This is great thank you

Thanks for such awesome stuff. Just wanted to check if GUID, Major, Minor remain same across different PCs, so that, the VBA code becomes fully portable and ready to use on any machine (No need to ask users to check library references) ?

First, Thanks for shearing a valuable info. Second Ms Access is also supportin the same VBA, how to set project variable in access

what is the name about the library to use the nomenclature VBIDE?

Great video. Have been looking for such a tutorial for a long time! :-)

Sir how can solve StrConv object error in VBA when i run the code then will come error "Can't find the Object in library" Please help me know how can solve the error.

Thank u so much

great. indeed handly.. can you make a video on "getobject" and "createobject" in vba.... thanks in advance

You are a the 🐐

Very useful video! Thanks.

great!!! thank you very much... greetings from Paraguay

Very useful video! Thanks

Hi. It is fine if you know the library Name and path in your computer. But it is not usable if you prepare tool for somebody else and you do not know exact version. I just need to add Outlook library if it is not there implemented yet. So something more universal would be fine.

Nice lesson! But, I would like to add library of System.Text.ASCIIEncoding to convert Hex to sjis. Thanks!

You are enable libraries with code to make the user's life easier, nevertheless we would have to enable VB for application extensibility first? That doesn't make sense to me...

Thanks buddy, this video helped me a lot :)

Ajudou muito, eu lhe agradeço de coração.

How to add our function into library?

Thanks you sir a lot, very useful rly

thx indeed, been looking for this kind of tut, grat one. I'll subscribe :)

You are doing great.

good stuff, subscribed!

I am not getting VB IDE in my Editor

Thanks