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

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.

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" wrote in message
...
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.