Hi. I have a macro which processes multiple workbooks copied into sheet2. I want to save the result in the same folder as the summarised wbs. Problem I'm having is that although all wb to be summarised will come from the same folder, that will vary so path will have to be derived from the copied wbs. Also dont want summary to incorporate original file name. After save user to revert back to the original macro enabled wb so they can do another selection or manually close it. All solutions I can find seem to need original wb name incorporated in new file name, or for save path to be pre determined. Help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
