Error due to file name change

Hello, I am trying to use the following macro but it keeps returning an error due to the name change. Can anyone point me in the right direction?

Please Login or Register  to view this content.

Thank you for any help in advance

In VBA, problems are reduced when you reference your workbooks and sheets by variable instead of hardcoding, wherever possible.

Also, selecting and activating can be reduced to a minimum. In VBA, once you have workbk and worksh identified, you can address your commands to them directly by using a complete reference command.

This shows how to use the workbook the macro is installed into as a variable workbook reference without ever knowing what the name of the workbook is, then how to copy sheets using that variable...without activating/selecting first.

Please Login or Register  to view this content.