accessing data from other workbook

[Tony]

Is there any way to access data from the unopened
workbook ??? I would like to use in the procedure data
from the workbook without opening it. Is it possible ?
How ?

Regards,

Tony

 

[TroyW]

Here is one possibility. You can use a formula in File1 to reference a cell
in File2:

A1: =[File2.xls]Sheet1!$A$1
or
A1: ='C:\My Documents\Excel\Junk1\[File2.xls]Sheet1'!$A$1

You will be asked to update the data when the file is opened.

The easiest way to create the formulas is to have both workbooks open in the
same Excel session. You can type "=" in the cell and then navigate to the
other file and click on the cell you want to link to.

Troy

 

[Tony]

Thank you for your response. But it is not what I need. I
would like to use this reference not in the cell but in
the procedure. Could it be done ?

Regards,

Tony

-----Original Message-----
Here is one possibility. You can use a formula in File1 to reference a cell
in File2:

A1: =[File2.xls]Sheet1!$A$1
or
A1: ='C:\My Documents\Excel\Junk1\[File2.xls]Sheet1'!$A$1

You will be asked to update the data when the file is opened.

The easiest way to create the formulas is to have both workbooks open in the
same Excel session. You can type "=" in the cell and then navigate to the
other file and click on the cell you want to link to.

Troy

Is there any way to access data from the unopened
workbook ??? I would like to use in the procedure data
from the workbook without opening it. Is it possible ?
How ?

Regards,

Tony

.

 

[Bob Phillips]

Why not just open it, get your data, and then close it again?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Thank you for your response. But it is not what I need. I
would like to use this reference not in the cell but in
the procedure. Could it be done ?

Regards,

Tony

-----Original Message-----
Here is one possibility. You can use a formula in File1 to reference a cell
in File2:

A1: =[File2.xls]Sheet1!$A$1
or
A1: ='C:\My Documents\Excel\Junk1\[File2.xls]Sheet1'!$A$1

You will be asked to update the data when the file is opened.

The easiest way to create the formulas is to have both workbooks open in the
same Excel session. You can type "=" in the cell and then navigate to the
other file and click on the cell you want to link to.

Troy

Is there any way to access data from the unopened
workbook ??? I would like to use in the procedure data
from the workbook without opening it. Is it possible ?
How ?

Regards,

Tony

.

 

[TroyW]

Tony,

You can use ADO to read directly from a closed Excel file. See the following
MSKB article.

http://support.microsoft.com/default.aspx?kbid=278973

Troy

Thank you for your response. But it is not what I need. I
would like to use this reference not in the cell but in
the procedure. Could it be done ?

Regards,

Tony

-----Original Message-----
Here is one possibility. You can use a formula in File1 to reference a cell
in File2:

A1: =[File2.xls]Sheet1!$A$1
or
A1: ='C:\My Documents\Excel\Junk1\[File2.xls]Sheet1'!$A$1

You will be asked to update the data when the file is opened.

The easiest way to create the formulas is to have both workbooks open in the
same Excel session. You can type "=" in the cell and then navigate to the
other file and click on the cell you want to link to.

Troy

Is there any way to access data from the unopened
workbook ??? I would like to use in the procedure data
from the workbook without opening it. Is it possible ?
How ?

Regards,

Tony

.