I would like to provide a button on my spreadsheet to allow the user to search down thru folders on the c drive to select a file somewhere on the computer. I'm not sure how to reference it, but it should work like "windows explorer" where you can click on a folder to open - then maybe a sub folder until you find the file you would like to select.
The purpose is to import a text file into excel without using a macro, and import text files with different names ( one at a time ).
I think I can mke it work after selecting the fle, but need help in making that selection possible. I have seen references to comdlg32 and msofilepicker but can't do anything with these.
any help will be appreciated
Thank you
The purpose is to import a text file into excel without using a macro, and import text files with different names ( one at a time ).
I think I can mke it work after selecting the fle, but need help in making that selection possible. I have seen references to comdlg32 and msofilepicker but can't do anything with these.
any help will be appreciated
Thank you