programming a link
 

Hello, can anyone help?

I have a workbook named 16_04_abc.xls where 16 is the
week number and 04 the year number.
It is a rolling sheet and so when week 16 is complete a
macro attached to a button prepares week 17 for data
input etc, until this point 17_04_abc.xls does not exist.
The workbook has 2 sheets.

Now alot of the info on in the workbook sheet1 needs to
be transfered to another workbook. The other workbook
details months.

I know a cell in the other workbook can say
=C:\[16_04_abc.xls]Sheet1$A$1 but what about references
to files that don't exist yet. I get #Ref errors.

So, i would like to have the user input a row number and
a week number and to have a macro input into the relevant
cell the formula to pull in the figure from the first
workbook.
I can get it to display the correct formula in the cell
but this is as text not a formula.

Can anyone help solve my problem?

Cheers

Joe