Hi there,
I ran a macro that will open other workbooks, copy and paste certain information from the other workbook and paste the Master Workbook. There are 50+ workbooks, so it works on a loop. It worked fine.
I had to restart my computer and when I went to rerun the macro on a different folder, the macro doesn't run anymore. No error message, it just won't the run.
What's troubling is that when I create a second module in the Master Workbook and get to open 1 workbook from the new file, the workbook opens. So I know it's not a filepath issue or a connectivity issue (other workbooks are saved on a server). It also tells me macros aren't disabled.
How can I get the macro to run again? I still got 3 more folders to go, each with 50+ workbooks to copy the information from.
Thanks for any help on this.
I ran a macro that will open other workbooks, copy and paste certain information from the other workbook and paste the Master Workbook. There are 50+ workbooks, so it works on a loop. It worked fine.
I had to restart my computer and when I went to rerun the macro on a different folder, the macro doesn't run anymore. No error message, it just won't the run.
What's troubling is that when I create a second module in the Master Workbook and get to open 1 workbook from the new file, the workbook opens. So I know it's not a filepath issue or a connectivity issue (other workbooks are saved on a server). It also tells me macros aren't disabled.
How can I get the macro to run again? I still got 3 more folders to go, each with 50+ workbooks to copy the information from.
Thanks for any help on this.