Hi
I'm trying to write some code that will split out worksheets from my workbook and save them to a user selected directory. The directory may or may not exist at the time of running the code.
How can I get a pop window that will allow the user to navigate to\create the save directory but will not require the 'save name' as I want the macro to assign the name for the workbook
Thanks
Jim
I'm trying to write some code that will split out worksheets from my workbook and save them to a user selected directory. The directory may or may not exist at the time of running the code.
How can I get a pop window that will allow the user to navigate to\create the save directory but will not require the 'save name' as I want the macro to assign the name for the workbook
Thanks
Jim