Hi TwEaKFrEaK ;


Go into VBA help and look at the topic for the ChangeLink
Method.

Thanks,

Greg


-----Original Message-----
Below is the a portion of a macro that I am creating.

Range("L56").Select
Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = _
"='S:\Local Disk\Data\2004\Quarter 2, 2004\[Data Entry
Form.xls]Performance'!$A$2:$J$402"

ActiveWorkbook.Names.Add Name:="Data1", RefersToR1C1:= _
"='S:\Local Disk\Data\2004\Quarter 2, 2004\[Data Entry
Form.xls]Performance'!R2C1:R402C10"

I would like to macro to copy a cells contents. Right
now its coping a
specific formula that is in L56 but if I change the
filepath on the
sheet (L56) the macro changes it back to the original
(i.e, "='S:\Local
Disk\Data\2004\Quarter 2, 2004\[Data Entry
Form.xls]Performance'!$A$2:$J$402")

Since the filename changes every quarter I want to macro
to copy the
contents in cell L56 but I do not want to see the actual
file name in
the macro. I think it has to be like a wildcard. (In L56
I will
generate the current directory and file name based on an
input sheet.)

I know this is confusing, you have any other questions
please let me
know. Thank you so much for your help. Your expertise is
appreciated.


---
Message posted from http://www.ExcelForum.com/

.