M
M.A.Tyler
I have a workbook that I use almost daily, when I'm finished I save the
workbook to a different name, and reuse the original the next time. All the
macros associated work fine in the saved file with the new name. Recently I
added a new macro and prior to the save operation it works fine. However
after saving it, it needs to open the original file to run the macro? Even
then it won't perform the task because wants to run the application on the
original workbook. I recorded the macro using the macro recorder in the
original workbook, so I understand why it's happening, just don't know enough
about how to fix it. The code goes something like this: Application. Run
"Test.00.xls! tester". Test.00.xls refers to the original workbook, can that
be changed somehow to ActiveWorkbook, so it will work from each subsequent
saved file?
Thanks,
Mike.
workbook to a different name, and reuse the original the next time. All the
macros associated work fine in the saved file with the new name. Recently I
added a new macro and prior to the save operation it works fine. However
after saving it, it needs to open the original file to run the macro? Even
then it won't perform the task because wants to run the application on the
original workbook. I recorded the macro using the macro recorder in the
original workbook, so I understand why it's happening, just don't know enough
about how to fix it. The code goes something like this: Application. Run
"Test.00.xls! tester". Test.00.xls refers to the original workbook, can that
be changed somehow to ActiveWorkbook, so it will work from each subsequent
saved file?
Thanks,
Mike.