You can link to a file with formulas. You can access it using ADO.

http://support.microsoft.com/default...b;en-us;246335
How To Transfer Data from an ADO Recordset to Excel with Automation

http://support.microsoft.com/kb/257819/EN-US/
How To Use ADO with Excel Data from Visual Basic or VBA

http://support.microsoft.com/kb/278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/kb/247412
INFO: Methods for Transferring Data to Excel from Visual Basic

http://support.microsoft.com/kb/172267/EN-US/
SAMPLE: RECEDIT.VBP Demonstrates File I/O in Visual Basic

--
Regards,
Tom Ogilvy

"hedia.chen" wrote in message
...
I want to use data of unopen another excel file.how do?must use data of
file
after openning?