Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Username Accessing Workbook | Setting up and Configuration of Excel | |||
Accessing a single worksheet in a workbook | Excel Programming | |||
Accessing Closed Workbook | Excel Programming | |||
Accessing Data from Closed Workbook | Excel Programming | |||
Accessing Data from Closed Workbook | Excel Programming |