link two workbooks

[bill_morgan_3333]

Friends,

Is there a way to link the cells in WorkbookA.Sheet1 to the cells in
WorkbookB.Sheet1 without having the link formula appear inside the cells of
WorkbookA.Sheet1?

Or is copy \ paste special \ links the only type of link that can be created
between two workbooks?

I am trying to create a macro that: 1) clears the data (so that nothing
appears in the linked cells); 2) updates the link (so that only values (not
link formulas) appear in the updated cells).

Thanks,

Bill Morgan

 

[Rick B]

This is a Microsoft ACCESS DAOVBA workgroup. Nothing to do with Excel.

Rick B

 

[bill_morgan_3333]

oops ... picked wrong section ... thanks ...

This is a Microsoft ACCESS DAOVBA workgroup. Nothing to do with Excel.

Rick B