Nice Andrew. I was using late binding already but the new thing that I learnt in this video was to find the constants enumeration values right inside the VBE. late binding is a blessing for developers however I still could not find a way to use it for Mac users. Please let me know if you have any idea about that. Thanks
Hi Imran! I'm afraid that my knowledge of VBA for Mac is extremely limited so I can't offer much advice on that. I always refer to Ron de Bruin for Mac Excel information www.macexcel.com/ I don't know if he has information on that topic but it's worth a look!
Great video, which inspired me for a question: How do you reference for early binding a library or a member of a class from within the code, instead of setting the reference in the Tools menu. Using your code, I would like to reference from within the code the ParagraphFormat class and it's members, specifically from your example the member Alignment to understand the constant/member wdAlignParagraphCenter. I hope I'm writing this correctly.
Hi Roland! Yes you can add references to object libraries programmatically using two different methods: docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/addfromfile-method-vba-add-in-object-model docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/addfromguid-method-vba-add-in-object-model You can see more useful examples in the answers to this post stackoverflow.com/questions/3837720/how-do-i-programatically-add-a-reference-to-a-vba-project I hope it helps!
Hi there! It's difficult to say without more details. What does your code look like and which line is causing the problem? Perhaps these might help stackoverflow.com/questions/62239548/vba-selenium-class-not-registered-80040154 answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/previously-working-macro-enabled-file-now-throwing/600cc674-733a-4481-9cd1-1f836df9be84
Just one question about early binding. I find it convenient to use the New keyword when declaring the variable all in one line. Is there any reason why this shouldn't be done?
Hi there! There are some very minor reasons why you might consider not using that style of variable declaration: 1 - You can't test if the variable Is Nothing because as soon as you reference it, it instantly becomes something (as the most likely reason for testing that it Is Nothing is because you want to make it something, this is rarely a problem). 2 - The variable is tested for Nothing each time it is referenced adding an overhead at runtime (but this has a negligible impact on performance so again, not a problem). I use either technique depending mainly on what mood I'm in. Others have stronger feelings on the subject www.cpearson.com/excel/DeclaringVariables.aspx I hope that helps!
I am no expert on this, but i understand you can create only one instance of the object with the single line format, but any number of objects with the separate line format.
hi what if i transfer the file where the word library activated reference to multiple users? do they need to activate the library for each users ? the same way that you did in the original file or no need to do that?
Hi Ed! If you set a reference to an object library using Tools | References like in the original file you can give this file to other users and if they have the same version of the software installed then they don't need to do anything. I hope that helps!
@@WiseOwlTutorials yes got that, but what if we are the not same version and some references and libraries on the wnd users are not set what if i forward the to a hundred user do they need to set the references and libraries. before using the file
@@edtardaguila3599 Hi Ed! If you're using early binding and your users have different versions then they will need to resolve the missing references as shown in the video, yes. I hope that helps!
Excellent explanation. Your clarity and thoroughness is much appreciated.
Thanks Jack, glad you found it useful and thank you for taking the time to leave a comment!
16:11 I hope nobody needs late binding on this reference, Great Scott!
this was so helpful, thank you so much!
You're very welcome, thanks for watching!
Very good! I will have use of this!
Glad you found it useful Henrik!
Great Sir!!! What an Awesome Idea to convert Early Binding to Late Binding code. Thanks for this training session. I really enjoy Sir.
Thanks Pankaj, glad you liked it!
Very very good explanation!!! This helps a lot!
Glad you enjoyed it Bernhard, thank you for the comment!
Thank you for explaining it so well.
You're very welcome Debbie, thank you for watching!
Thank you for another great video!
You're welcome Piotr, thanks for watching!
Another great video!
Thanks Terry!
Thanks Andrew, great explanation of early versus late binding. I usually use late binding when creating emails from Excel. Just habit I guess.
Thanks Kevin! You have a better memory than I do, I clearly rely on the IntelliSense too much!
Thank you very much for these awesome videos.
You are always welcome Yasser!
I am through the video, Very beautiful and nice explanations and informative as well. Thank you sir.
That was fast! Glad you enjoyed it Rohith, thank you for watching!
Nice Explanation..
Thank you!
thks again from Montreal (Canada) :-))
You're welcome Mario, thank you for watching!
Great again, keep up the good work sir... U r sharing the vast knowledge with us... Happy to be a subsriber
Thank you Anil, happy to hear that you enjoyed it!
Nice Andrew. I was using late binding already but the new thing that I learnt in this video was to find the constants enumeration values right inside the VBE. late binding is a blessing for developers however I still could not find a way to use it for Mac users. Please let me know if you have any idea about that. Thanks
Hi Imran! I'm afraid that my knowledge of VBA for Mac is extremely limited so I can't offer much advice on that. I always refer to Ron de Bruin for Mac Excel information www.macexcel.com/
I don't know if he has information on that topic but it's worth a look!
Thanks so much.
My pleasure Youssef, thank you for your comments!
Thanks a lot, it's awesome.
Glad you liked it Hassan!
Really good
Thank you!
Great video, which inspired me for a question: How do you reference for early binding a library or a member of a class from within the code, instead of setting the reference in the Tools menu. Using your code, I would like to reference from within the code the ParagraphFormat class and it's members, specifically from your example the member Alignment to understand the constant/member wdAlignParagraphCenter. I hope I'm writing this correctly.
Hi Roland! Yes you can add references to object libraries programmatically using two different methods:
docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/addfromfile-method-vba-add-in-object-model
docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/addfromguid-method-vba-add-in-object-model
You can see more useful examples in the answers to this post stackoverflow.com/questions/3837720/how-do-i-programatically-add-a-reference-to-a-vba-project
I hope it helps!
what does it mean if a "class not registered" error is received and how to resolve it?
Hi there! It's difficult to say without more details. What does your code look like and which line is causing the problem?
Perhaps these might help
stackoverflow.com/questions/62239548/vba-selenium-class-not-registered-80040154
answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/previously-working-macro-enabled-file-now-throwing/600cc674-733a-4481-9cd1-1f836df9be84
I've heard that some libraries run faster when using early binding such as dictionary libraries. I'm not sure though.
Hi Rafael, I hadn't heard this, that's interesting, thank you for sharing!
Just one question about early binding. I find it convenient to use the New keyword when declaring the variable all in one line. Is there any reason why this shouldn't be done?
Hi there! There are some very minor reasons why you might consider not using that style of variable declaration:
1 - You can't test if the variable Is Nothing because as soon as you reference it, it instantly becomes something (as the most likely reason for testing that it Is Nothing is because you want to make it something, this is rarely a problem).
2 - The variable is tested for Nothing each time it is referenced adding an overhead at runtime (but this has a negligible impact on performance so again, not a problem).
I use either technique depending mainly on what mood I'm in. Others have stronger feelings on the subject www.cpearson.com/excel/DeclaringVariables.aspx
I hope that helps!
I am no expert on this, but i understand you can create only one instance of the object with the single line format, but any number of objects with the separate line format.
hi what if i transfer the file where the word library activated reference to multiple users? do they need to activate the library for each users ? the same way that you did in the original file or no need to do that?
Hi Ed! If you set a reference to an object library using Tools | References like in the original file you can give this file to other users and if they have the same version of the software installed then they don't need to do anything.
I hope that helps!
@@WiseOwlTutorials yes got that, but what if we are the not same version and some references and libraries on the wnd users are not set what if i forward the to a hundred user do they need to set the references and libraries. before using the file
@@edtardaguila3599 Hi Ed! If you're using early binding and your users have different versions then they will need to resolve the missing references as shown in the video, yes. I hope that helps!
@@WiseOwlTutorials thanks i got it clear :)
@@edtardaguila3599 You're welcome Ed!