Hi,
I have recorded a macro that copys data from one workbook to another and it works fine for the books it was recorded in. But I need to use the macro in many other books, all with different names.
There must be a line of code that will cause the other open workbook to activate. There will only be two workbooks open and both will have different names each time the macro is needed.
I've searched back through the messages to find a similar question. There are some, but I couldn't quite figure them out. I'm very much a beginner at macros. Using Excel 97.
Thank you for any help.
I have recorded a macro that copys data from one workbook to another and it works fine for the books it was recorded in. But I need to use the macro in many other books, all with different names.
There must be a line of code that will cause the other open workbook to activate. There will only be two workbooks open and both will have different names each time the macro is needed.
I've searched back through the messages to find a similar question. There are some, but I couldn't quite figure them out. I'm very much a beginner at macros. Using Excel 97.
Thank you for any help.