Easy VBA File Selection Window to Open Files in Excel

[@daleanderson5258]

Great info and video. Makes me want to take a look at the complete course.

[@TeachExcel]

That's great to hear! :) I am really trying to make it a useful learning experience hope it will benefit everyone)

[@KnuYorker]

Excellent! I had done this before, and really botched it up. Now I can make it work properly thanks to this tutorial.

[@TeachExcel]

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.

[@ilotvin]

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...

[@TeachExcel]

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

[@NeangBona]

Very useful such a vba thank you for sharing TeachExcel !

[@TeachExcel]

You're very welcome! Glad you found it useful)

[@townnet]

How about open specific folder so I no need search the folder?

[@dennisnjoroge5478]

How I do I open word files?

[@pratik9217]

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?

[@meelhouse7924]

How can I save any file type to a specific location in vba using the userSelectedFile option? Someone please help.