Thank you! A few really serious coins dropped to me today regarding the logic behind the file opening process. I also realized that I can actually save all of the scenarios and use it as template for future work. Also It occurred to me to me that I should unhide the file extension permanently in the Widows settings (as I always need to look at the text description). That will definitely facilitate a bit my life...
You are very welcome! I am glad to help! The file extension thing is a great point and I probably should have mentioned that earlier on in the tutorial. And yes, definitely save code that works so you can use it in the future. I feel like 90% of programming is copy/pasting boilerplate code haha
I'm calling a macro from single click vbs---but when via this the GetOpenFileName is not coming in forefront when called from vbs---how can it be resolved?
Excellent! I had done this before, and really botched it up. Now I can make it work properly thanks to this tutorial.
I'm very glad to help! I think sometimes people use the more complex FileDialog setup to do this and that just isn't required in most cases.
Great info and video. Makes me want to take a look at the complete course.
That's great to hear! :) I am really trying to make it a useful learning experience hope it will benefit everyone)
Thank you!
A few really serious coins dropped to me today regarding the logic behind the file opening process.
I also realized that I can actually save all of the scenarios and use it as template for future work.
Also It occurred to me to me that I should unhide the file extension permanently in the Widows settings (as I always need to look at the text description).
That will definitely facilitate a bit my life...
You are very welcome! I am glad to help! The file extension thing is a great point and I probably should have mentioned that earlier on in the tutorial. And yes, definitely save code that works so you can use it in the future. I feel like 90% of programming is copy/pasting boilerplate code haha
How about open specific folder so I no need search the folder?
Very useful such a vba thank you for sharing TeachExcel !
You're very welcome! Glad you found it useful)
How I do I open word files?
I'm calling a macro from single click vbs---but when via this the GetOpenFileName is not coming in forefront when called from vbs---how can it be resolved?
How can I save any file type to a specific location in vba using the userSelectedFile option? Someone please help.