Greetings from Egypt. My implementation of your "Art" after over 100hrs of studying and repeating your "Art" videos throughout your "Art channel" got me a dream job remotely, so you deserves a golden like and a prober thanks comment at least .
I am not finished my comment :D. So, for anyone who want mastering Excel VBA, Mr. Randy is the boss. Anyway, thank you very much Randy for your great efforts and may success follow you every step of the way.
Randy, did you know, when you want to copy a line or lines of code like you did in this video, all you have to do is select the part you want to copy (like you did) and hold CTRL and drag the selection to the new location? Might be a good tip for the newbies.
Hi and thanks very much Peter. I do have an entire video on objects here: ruclips.net/video/zgN_VNSgmeg/видео.html VBA code is great anytime you want to use automation or do take actions on things like a button click or worksheet event. I hope this helps and thanks so much.
Thanks"Great VBA class! Your explanations are so clear and helpful. Could you please consider doing an email master class next time? It would be really beneficial for us learners. Looking forward to more tutorials from you!"
Thank you so much for your guidance! I'll definitely look forward to your video and learn how to automatically save files from specific Mail to a specific folder. I'll patiently await it.
Hi and thanks if you are looking to save email to a folder you can check out this training series here: ruclips.net/p/PLIBeRriXvKzCtG5-PCCrGmlarvBC0UlGI I hope this helps and thanks so much.
Hi Randy. Thanks for the excellent video. Could you please consider making another video showing how to manipulate files and folders that are stored in Microsoft sharepoint locations via VBA? Thanks.
Interesting! I think FSO is more comprehensive as far as methods and properties (and it's cool to use too), but I didn't realize there was actually a VBA equivalent for some of these common uses.
Yes thanks so much. I tend to use both during applications depending upon the application requirements. Thank you for your Likes, Shares & Comments. It really helps.
good educational video. 2 questions. Is this late binding or early binding? These examples are static. perhaps in the future an instruction video on how you can define the folder or file yourself from a form, for example. Thx
Hi and thanks you can check the FSO library of commands. It may be possible with the FIle System Object however I have not personally researched it at this time. Thanks again for your continued support.
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Greetings from Egypt. My implementation of your "Art" after over 100hrs of studying and repeating your "Art" videos throughout your "Art channel" got me a dream job remotely, so you deserves a golden like and a prober thanks comment at least .
Great to hear that. Thanks so much and I am really happy to help and share
I am not finished my comment :D. So, for anyone who want mastering Excel VBA, Mr. Randy is the boss. Anyway, thank you very much Randy for your great efforts and may success follow you every step of the way.
Thank you so very much, I really appreciate that Ahmed. very kind of you
Randy, did you know, when you want to copy a line or lines of code like you did in this video, all you have to do is select the part you want to copy (like you did) and hold CTRL and drag the selection to the new location? Might be a good tip for the newbies.
Great tip thanks so much. I will be practicing that even more than before. Thank you for your Likes, Shares & Comments. It really helps.
Smashing.
My only criticisms are:
1) how does one know if something is an object
2) why and when does one know when to use "script"
Hi and thanks very much Peter. I do have an entire video on objects here: ruclips.net/video/zgN_VNSgmeg/видео.html
VBA code is great anytime you want to use automation or do take actions on things like a button click or worksheet event.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks so much
Thanks"Great VBA class! Your explanations are so clear and helpful. Could you please consider doing an email master class next time? It would be really beneficial for us learners. Looking forward to more tutorials from you!"
Hi and thanks. I think that is a great idea. I have many on email, however nothing for basic learners. I will get it done this week. Thanks again
Thank you so much for your guidance! I'll definitely look forward to your video and learn how to automatically save files from specific Mail to a specific folder. I'll patiently await it.
Hi and thanks if you are looking to save email to a folder you can check out this training series here:
ruclips.net/p/PLIBeRriXvKzCtG5-PCCrGmlarvBC0UlGI
I hope this helps and thanks so much.
Thank you so much
Wonderful! This is essential stuff, Randy. Thank you very much.
Great, and thanks so much. I am really glad you enjoyed the training
You are the best.
⭐⭐⭐⭐⭐
Thank you so very much, I really appreciate that
Hi Randy. Thanks for the excellent video. Could you please consider making another video showing how to manipulate files and folders that are stored in Microsoft sharepoint locations via VBA? Thanks.
Hi and thanks so much. That is a nice idea and I will write that down for a future video. Much appreciated.
Interesting! I think FSO is more comprehensive as far as methods and properties (and it's cool to use too), but I didn't realize there was actually a VBA equivalent for some of these common uses.
Yes thanks so much. I tend to use both during applications depending upon the application requirements. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for the course, this is really make easy for my some macros.
Great. I am very happy to help and share and glad you love the training
Thanks Appreciate it
For sure, you are very welcome and I am happy to help and share
Thanks for this formation it very good for us
For sure, you are very welcome Oliver and thanks for your many years of support. I really appreciate it
Great work. FIrst time watching. I will be back.
Awesome. Thanks so much and great to have you here :)
Top............Thank you very much.
Thanks so very much Henk. I really appreciate your continued support.
Great video.
I use shell...combined with dictionary to store the files names. Is faster than fso. But this is me.
Great information. Thank you for your Likes, Shares & Comments. It really helps.
Oooh this is dangerous stuff
For sure not dangerous but very powerful and helpful. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for the info..
For sure, you are very welcome and thanks so much for watching
very good thank you
Great, thanks so much. I am glad you enjoyed it
good educational video. 2 questions.
Is this late binding or early binding?
These examples are static.
perhaps in the future an instruction video on how you can define the folder or file yourself from a form, for example.
Thx
Hi and thanks so much. This uses late binding so that there is no need to attach additional libraries. I hope this helps and thanks so much.
I need to figure out how to use relative references. Any suggestions?
Hi and thanks. It depends what type of references. You can search the use of the INDIRECT function. I hope this helps and thanks so much.
Never tried this before.
Oh great, I am sure you will use it a lot in the future. Thank you for your Likes, Shares & Comments. It really helps.
Is it possible to check if the file is open by someone else no matter a normal file or shared file?
Hi and thanks you can check the FSO library of commands. It may be possible with the FIle System Object however I have not personally researched it at this time. Thanks again for your continued support.
💪💪
Thank you so very much, I really appreciate that