|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 01:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com