| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
READING values from a closed workbook
I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Try something like the following:
Dim Res As Variant Res = Application.ExecuteExcel4Macro("'H:\[Book1.xls]Sheet1'!R1C1") Debug.Print Res -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kev_06" wrote in message ... I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Hi Kevin,
See John Walkenbach at: http://www.j-walk.com/ss/excel/tips/tip82.htm --- Regards, Norman "kev_06" wrote in message ... I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Kev,
A file must be opened to read data from it. Mike "kev_06" wrote: I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Perhaps this will be more to your liking...
http://www.dailydoseofexcel.com/arch...ing-workbooks/ -- HTH... Jim Thomlinson "kev_06" wrote: I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
A file must be opened to read data from it.
Not true. See my reply. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crazybass2" wrote in message ... Kev, A file must be opened to read data from it. Mike "kev_06" wrote: I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Not really you can use ado or xl4 macros... check out this link...
http://www.dailydoseofexcel.com/arch...ing-workbooks/ -- HTH... Jim Thomlinson "crazybass2" wrote: Kev, A file must be opened to read data from it. Mike "kev_06" wrote: I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Thanks Jim and Chip! That's what I love about this group. I always learn
something new. Mike "Chip Pearson" wrote: A file must be opened to read data from it. Not true. See my reply. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "crazybass2" wrote in message ... Kev, A file must be opened to read data from it. Mike "kev_06" wrote: I'm trying to read values from a closed workbook. I'm using an If... Then statement to analyze the values in the closed workbook and then return a result in the current workbook. I've seen the code from Ron de Bruin and on the website, but everything I find is not what I'm looking for. I only need to read, not copy, values from a closed workbook. Is it possible? -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
READING values from a closed workbook
Thanks guys, I think that will work. -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=561630 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading values from a closed workbook | New Users to Excel | |||
| Get values from a closed workbook | Excel Programming | |||
| Getting Values From A Closed Workbook | Excel Programming | |||
| Reading information from a closed workbook | Excel Programming | |||
| Reading from a closed workbook | Excel Programming | |||
![kev_06[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
