How do I link data from another workbook using a different file na

[Victor]

I'm trying to link data from a source workbook to a destination workbook
using a different filename. Also the data will be save in several worksheets.
I would like to keep a history of the link data for each worksheet. Which is
the best way to execute this task.

[CLR]

This formula, when placed in a cell in your current workbook, will draw the
value from cell A1 of the Workbook1.xls file from the specified directory.

='C:\My Documents\[workbook1.xls]Sheet1'!A1

Vaya con Dios,
Chuck, CABGx3



"Victor" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to link data from a source workbook to a destination workbook
> using a different filename. Also the data will be save in several
worksheets.
> I would like to keep a history of the link data for each worksheet. Which
is
> the best way to execute this task.