|
Pull Data from a closed workbook, without opening it.
Does anyone know the code to use to be able to pull data from a closed workbook, without opening it?
|
Pull Data from a closed workbook, without opening it.
Harlan Grove posted a function that opens another instance of excel and then
retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson |
Pull Data from a closed workbook, without opening it.
without opening it?
I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of excel and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson |
Pull Data from a closed workbook, without opening it.
I would go with a link in a cell, if the cell in the workbook you ar
looking for is always changeing try using vlookup. Keith www.kjtfs.com Tom Ogilvy wrote: * without opening it? I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simpl putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of exce and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from closed workbook, without opening it? -- Dave Peterson -- Message posted from http://www.ExcelForum.com |
Pull Data from a closed workbook, without opening it.
Harlan corrected me on this one, too. I once posted that it starts another
instance of excel and opens the other file there and retrieves the value. Actually, it uses the same techniques that John Walkenbach does to retrieve a value from a closed workbook. But it wouldn't be necessary to use Harlan's routine in a case where the macro itself will retrieve the value. To the OP: Harlan's routine is very nice when called from a worksheet where the closed workbook can vary (based on another cell--and =indirect() would be used. And in the most basic sense, I guess I agree with You and Keith--just use a formula in a cell that would point to the cell you want to retrieve. Tom Ogilvy wrote: without opening it? I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of excel and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson -- Dave Peterson |
Pull Data from a closed workbook, without opening it.
And if the OP wants to use the John Walkenbach's techniques:
http://j-walk.com/ss/excel/eee/eee009.txt Look for either: GetDataFromClosedFile or GetValue. Dave Peterson wrote: Harlan corrected me on this one, too. I once posted that it starts another instance of excel and opens the other file there and retrieves the value. Actually, it uses the same techniques that John Walkenbach does to retrieve a value from a closed workbook. But it wouldn't be necessary to use Harlan's routine in a case where the macro itself will retrieve the value. To the OP: Harlan's routine is very nice when called from a worksheet where the closed workbook can vary (based on another cell--and =indirect() would be used. And in the most basic sense, I guess I agree with You and Keith--just use a formula in a cell that would point to the cell you want to retrieve. Tom Ogilvy wrote: without opening it? I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of excel and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Pull Data from a closed workbook, without opening it.
Ok, I stand corrected, but then it does incur overhead beyond John's
technique. In any event, I wouldn't use the word "nice" to describe opening another instance of Excel in a UDF/as part of the calculation chain, but if the requirement is essential, then it does the job. <g -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan corrected me on this one, too. I once posted that it starts another instance of excel and opens the other file there and retrieves the value. Actually, it uses the same techniques that John Walkenbach does to retrieve a value from a closed workbook. But it wouldn't be necessary to use Harlan's routine in a case where the macro itself will retrieve the value. To the OP: Harlan's routine is very nice when called from a worksheet where the closed workbook can vary (based on another cell--and =indirect() would be used. And in the most basic sense, I guess I agree with You and Keith--just use a formula in a cell that would point to the cell you want to retrieve. Tom Ogilvy wrote: without opening it? I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of excel and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson -- Dave Peterson |
Pull Data from a closed workbook, without opening it.
I only meant nice when you'd have to use =indirect().
And I agree wholeheartedly about overkill in some (this??) case. But sometimes answers come from muscle memory--not the grey wet stuff. Happy New Year. Tom Ogilvy wrote: Ok, I stand corrected, but then it does incur overhead beyond John's technique. In any event, I wouldn't use the word "nice" to describe opening another instance of Excel in a UDF/as part of the calculation chain, but if the requirement is essential, then it does the job. <g -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan corrected me on this one, too. I once posted that it starts another instance of excel and opens the other file there and retrieves the value. Actually, it uses the same techniques that John Walkenbach does to retrieve a value from a closed workbook. But it wouldn't be necessary to use Harlan's routine in a case where the macro itself will retrieve the value. To the OP: Harlan's routine is very nice when called from a worksheet where the closed workbook can vary (based on another cell--and =indirect() would be used. And in the most basic sense, I guess I agree with You and Keith--just use a formula in a cell that would point to the cell you want to retrieve. Tom Ogilvy wrote: without opening it? I believe that opens the workbook, Dave. Maybe suggesting John Walkenbach's method, or use of ADO or simply putting a link in a cell (fastest) would be more appropriate. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Harlan Grove posted a function that opens another instance of excel and then retrieves the value from that closed workbook. http://google.com/groups?threadm=oZx...wsra nger.com Joe B. wrote: Does anyone know the code to use to be able to pull data from a closed workbook, without opening it? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 02:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com