accessing data from other workbook
 

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

accessing data from other workbook
 

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

accessing data from other workbook
 

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


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


.

accessing data from other workbook
 

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)

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


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


.

accessing data from other workbook
 

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


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


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


.