how to refer to a workbook which name changes over time?

[MJKelly]

Hi,

How can I refer to a workbook in a macro if the name of the workbook
changes over time? The workbook contains most of the data I use to
create new workbooks, however its name is changed to reflect the
version (date) of the data it contains. If I refer to the name in the
module and then the name changes the following week the macro won't
work (obviously).

Any ideas? I thought that maybe the name could be identified when the
workbook opens and that name is assigned to variable? (I am new at
this).

kind regards,
Matt

 

[Leith Ross]

Hi,

How can I refer to a workbook in a macro if the name of the workbook
changes over time? The workbook contains most of the data I use to
create new workbooks, however its name is changed to reflect the
version (date) of the data it contains. If I refer to the name in the
module and then the name changes the following week the macro won't
work (obviously).

Any ideas? I thought that maybe the name could be identified when the
workbook opens and that name is assigned to variable? (I am new at
this).

kind regards,
Matt

Hi Matt,

In your code, replace the name of the workbook that the macro runs in
with ThisWorkbook.

Sincerely,
Leith Ross