Hello all,

Can anyone help please?

I have a spreadsheet which is used for data input and e-
mailed. The receiver checks various details and alters as
necessary. The receiver also needs to input comparatives
from the previous year. The comparatives are on an
identical spreadsheet,albeit with a different name, in
lets say C:\archive. The archived file is 01_04_abc.xls
and the current file 01_05_abc.xls

Now the receivers are not too good with excel and so
cannot be trusted to enter formulae or links to the
archived spreadsheets. Moreover there is too much data
for them to manually input.

So, my question is, is there a way of getting formulae
into cells using vba? Again the formula needs to be eg
='C:\archive\[01_04_abc.xls]sheet1'!$A$1

Can it be done using input boxes or converting strings to
formulae?

Any help greatly appreciated.

Cheers

Joe