Directory Browser within a macro?
Posted by Daryl Searle on February 08, 2002 7:37 AM
I have written a macro that works in the following way.
I type the file name and path (of a chosen text file) into cell A1, I then click on a command button to run the macro and it opens the specified text file in Excel and manipulates it automatically.
Is there a way where I can click the command button and the macro opens some sort of directary browser where I can then select the text file and then return to the macro to continue manipulating the text.