📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
@ahmedamer-kozika
2 ай бұрын
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 .
@ExcelForFreelancers
2 ай бұрын
Great to hear that. Thanks so much and I am really happy to help and share
@whitefox8291
6 күн бұрын
Best VBA content. Thanks Randy!
@ExcelForFreelancers
6 күн бұрын
Thank you so very much, I really appreciate that and so glad to help and share
@markhuang368
2 ай бұрын
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.
@ExcelForFreelancers
2 ай бұрын
Hi and thanks so much. That is a nice idea and I will write that down for a future video. Much appreciated.
@abhaychamyal7730
3 ай бұрын
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!"
@ExcelForFreelancers
3 ай бұрын
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
@abhaychamyal7730
3 ай бұрын
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.
@ExcelForFreelancers
3 ай бұрын
Hi and thanks if you are looking to save email to a folder you can check out this training series here: kzitem.info/door/PLIBeRriXvKzCtG5-PCCrGmlarvBC0UlGI I hope this helps and thanks so much.
@abhaychamyal7730
3 ай бұрын
Thank you so much
@ahmedamer-kozika
2 ай бұрын
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.
@ExcelForFreelancers
2 ай бұрын
Thank you so very much, I really appreciate that Ahmed. very kind of you
@peterwooldridge7285
3 ай бұрын
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"
@ExcelForFreelancers
3 ай бұрын
Hi and thanks very much Peter. I do have an entire video on objects here: kzitem.info/news/bejne/252ExYqEjJmemJw 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.
@peterwooldridge7285
3 ай бұрын
@@ExcelForFreelancers thanks so much
@boodahbellie
3 ай бұрын
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.
@ExcelForFreelancers
3 ай бұрын
Great tip thanks so much. I will be practicing that even more than before. Thank you for your Likes, Shares & Comments. It really helps.
@graytonw5238
3 ай бұрын
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.
@ExcelForFreelancers
3 ай бұрын
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.
@GosCee
3 ай бұрын
Wonderful! This is essential stuff, Randy. Thank you very much.
@ExcelForFreelancers
3 ай бұрын
Great, and thanks so much. I am really glad you enjoyed the training
@wimschiphorst8541
3 ай бұрын
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
@ExcelForFreelancers
3 ай бұрын
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.
@khobk4436
3 ай бұрын
Thanks for the course, this is really make easy for my some macros.
@ExcelForFreelancers
3 ай бұрын
Great. I am very happy to help and share and glad you love the training
@oliviertawamo1420
3 ай бұрын
Thanks for this formation it very good for us
@ExcelForFreelancers
3 ай бұрын
For sure, you are very welcome Oliver and thanks for your many years of support. I really appreciate it
@Info-God
3 ай бұрын
Great video. I use shell...combined with dictionary to store the files names. Is faster than fso. But this is me.
@ExcelForFreelancers
3 ай бұрын
Great information. Thank you for your Likes, Shares & Comments. It really helps.
@sahralsahri7180
3 ай бұрын
You are the best. ⭐⭐⭐⭐⭐
@ExcelForFreelancers
3 ай бұрын
Thank you so very much, I really appreciate that
@VS-rh8rq
3 ай бұрын
Thanks Appreciate it
@ExcelForFreelancers
3 ай бұрын
For sure, you are very welcome and I am happy to help and share
@ziggle314
3 ай бұрын
Great work. FIrst time watching. I will be back.
@ExcelForFreelancers
3 ай бұрын
Awesome. Thanks so much and great to have you here :)
@sanathanisvolgs
3 ай бұрын
Thanks for the info..
@ExcelForFreelancers
3 ай бұрын
For sure, you are very welcome and thanks so much for watching
@henkvinck888
3 ай бұрын
Top............Thank you very much.
@ExcelForFreelancers
3 ай бұрын
Thanks so very much Henk. I really appreciate your continued support.
@akkintouch
3 ай бұрын
Is it possible to check if the file is open by someone else no matter a normal file or shared file?
@ExcelForFreelancers
3 ай бұрын
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.
@Dexter101x
3 ай бұрын
Oooh this is dangerous stuff
@ExcelForFreelancers
3 ай бұрын
For sure not dangerous but very powerful and helpful. Thank you for your Likes, Shares & Comments. It really helps.
@ericmorgan2285
3 ай бұрын
I need to figure out how to use relative references. Any suggestions?
@ExcelForFreelancers
3 ай бұрын
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.
@abouyoussef555
Ай бұрын
Hi sir... What about filepicker If show =-1..... Please a tutorial
@ExcelForFreelancers
Ай бұрын
Hi and thanks very much. the -1 means a file has been selected. I hope this helps and thanks so much.
@ranilan00
3 ай бұрын
💪💪
@ExcelForFreelancers
3 ай бұрын
Thank you so very much, I really appreciate that
@joemanflyer2001
3 ай бұрын
Never tried this before.
@ExcelForFreelancers
3 ай бұрын
Oh great, I am sure you will use it a lot in the future. Thank you for your Likes, Shares & Comments. It really helps.
Пікірлер: 55