Johnsonste
09-04-2009, 02:58 PM
Hi,
I have found some code that will allow me to select a file from the standard pop-up window and then insert the file name into a cell that I specify. How can I do this with a folder? I want to have the user click on a button that launches a macro that opens the standard "open file" window and allows the user to select a folder and hit open. After hitting open, the name and path of the folder should be inserted into a specific cell. This is only one folder - not a batch listing. Any ideas?
I have found some code that will allow me to select a file from the standard pop-up window and then insert the file name into a cell that I specify. How can I do this with a folder? I want to have the user click on a button that launches a macro that opens the standard "open file" window and allows the user to select a folder and hit open. After hitting open, the name and path of the folder should be inserted into a specific cell. This is only one folder - not a batch listing. Any ideas?