I want to create a command button that will allow me to browes my c:drive folders.
Currently, I have code that will import a spreadsheet. At present, the spreadsheet file name is HARD CODED into the macros "Transferspreedshhet acimport, 3, filename...." you get the picture. Subsequesntly if the spreadsheet file name I want to import changes I have to update the macro with the new file name.
My goal is to be able to create a button, much like a browes button, that will allow me to search for the file I want to import, select it, and then insert that file name into my macro code.
Is this an attainable goal
any advis would be appreciated