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,
@marcesil782 жыл бұрын
great!!! thank you very much... greetings from Paraguay
@mohammedalboainain9826 Жыл бұрын
That was great work., the only issue is that we still need to manually add the "Visual Basic For Applications" reference!
@armaghankhan39389 ай бұрын
Thanks I was searching for the same
@christianandreassen79904 жыл бұрын
Great video. Have been looking for such a tutorial for a long time! :-)
@SigmaCoding4 жыл бұрын
Glad you found it useful. :)
@borten3 жыл бұрын
Very useful video! Thanks
@SigmaCoding3 жыл бұрын
Glad it was helpful!
@deepakagrawal4654 жыл бұрын
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) ?
@danielantone62162 жыл бұрын
This is great thank you
@dparaguai3 жыл бұрын
Thanks buddy, this video helped me a lot :)
@josephbuckman1583 жыл бұрын
You are doing great.
@romariodaniel11522 жыл бұрын
You are a the 🐐
@karstengunner46763 жыл бұрын
Thank u so much
@gencgorani4 жыл бұрын
thx indeed, been looking for this kind of tut, grat one. I'll subscribe :)
@SigmaCoding4 жыл бұрын
Thanks for the sub!
@willterpening88724 жыл бұрын
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. +
@SigmaCoding4 жыл бұрын
Interesting, I never knew that so thank you for sharing. Maybe it has something to do with it being a "out of the package" add-in? That's the only thing I can think of at this point.
@scotolivera82074 жыл бұрын
Thanks you sir a lot, very useful rly
@HerculesSantosLoyola3 жыл бұрын
Ajudou muito, eu lhe agradeço de coração.
@lbalkin4 жыл бұрын
good stuff, subscribed!
@ilhankirbas81194 жыл бұрын
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.
@SigmaCoding4 жыл бұрын
You need to enable macros in the workbook, or in other words disable Macro Security.
@hamidshah093 жыл бұрын
First, Thanks for shearing a valuable info. Second Ms Access is also supportin the same VBA, how to set project variable in access
@fabianafirmo19265 жыл бұрын
what is the name about the library to use the nomenclature VBIDE?
@SigmaCoding5 жыл бұрын
Visual Basic Integrated Development Environment (VBIDE), that was my understanding since you're actually controlling the IDE.
@mscoder99024 жыл бұрын
Thanks
@SigmaCoding4 жыл бұрын
No problem
@howto...inexcelbyexcelguru65224 жыл бұрын
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.
@SigmaCoding4 жыл бұрын
You could use the GUID to add it. It would add it automatically then. Also the file path is the same for all systems so you would need to use the more general user path.
@ayaanansari47654 жыл бұрын
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.
@ricardobarros834 жыл бұрын
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...
@SigmaCoding4 жыл бұрын
Agreed, kind of defeats the purpose if the person is on a different version of Office than you are. However, in that case you could just use late binding instead.
@OmkarUmbre5 жыл бұрын
How to add our function into library?
@SigmaCoding5 жыл бұрын
Could you clarify what you're trying to do?
@nikunjrastogi18065 жыл бұрын
I am not getting VB IDE in my Editor
@SigmaCoding5 жыл бұрын
Were you getting a specific error or was it failing on a specific line of code?
@KhoaNguyen-fs6to3 жыл бұрын
Nice lesson! But, I would like to add library of System.Text.ASCIIEncoding to convert Hex to sjis. Thanks!