S
steve
I have a need to referencing another workbook, that will
not be open, where the name of this workbook will change
once every month or so. In the past I have always manual
changed all the cell formulas that references to this
workbook. But the number of them is increasing. Is their
any way I can reference a workbook that changes names
often?
I have looked into the address function hoping that I
would only have to change 1 cell but I could not get it
to work, I have tried to create a custom function where I
pass VBA a path/file/cell and get the cell value back but
that did not work either.
not be open, where the name of this workbook will change
once every month or so. In the past I have always manual
changed all the cell formulas that references to this
workbook. But the number of them is increasing. Is their
any way I can reference a workbook that changes names
often?
I have looked into the address function hoping that I
would only have to change 1 cell but I could not get it
to work, I have tried to create a custom function where I
pass VBA a path/file/cell and get the cell value back but
that did not work either.