Hi,
I have some script to save 4 text files from an excel workbook.
I want to be able to prompt at the start to ask which directory they want it in.
Is there a way to do this that brings up the explorer navigation window in the same way as it would if you clicked "Save As" manually?
Thanks
AW
I have some script to save 4 text files from an excel workbook.
I want to be able to prompt at the start to ask which directory they want it in.
Is there a way to do this that brings up the explorer navigation window in the same way as it would if you clicked "Save As" manually?
Thanks
AW