Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
interrogating a workbook WITHOUT opening it from VBA
Hi All
A few years ago i remember reading that it is possible to "get at" values stored in another workbook from VBA, without having to open that workbook. It went something like : range("c:\myfile.xls[Sheet1]!D2") etc etc Can someone remind me how to do this? Thanks Rog |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
interrogating a workbook WITHOUT opening it from VBA
Not sure if this was the way i read, but i found one way
to do it : just write the link in to the cell directly : eg range("a1").formula ="='X:\Derivatives\[he Euronext.xls] Automate'!AF70" If anyone has a better way, please advise! Cheers Rog -----Original Message----- Hi All A few years ago i remember reading that it is possible to "get at" values stored in another workbook from VBA, without having to open that workbook. It went something like : range("c:\myfile.xls[Sheet1]!D2") etc etc Can someone remind me how to do this? Thanks Rog . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
interrogating a workbook WITHOUT opening it from VBA
Roger,
Here is one method. Read the caveat at the bottom of the page carefully. http://www.j-walk.com/ss/excel/tips/tip82.htm Another method would be to use ADO to work with the Excel file directly http://support.microsoft.com/default...b;en-us;278973 Troy "Roger Butler" wrote in message ... Not sure if this was the way i read, but i found one way to do it : just write the link in to the cell directly : eg range("a1").formula ="='X:\Derivatives\[he Euronext.xls] Automate'!AF70" If anyone has a better way, please advise! Cheers Rog -----Original Message----- Hi All A few years ago i remember reading that it is possible to "get at" values stored in another workbook from VBA, without having to open that workbook. It went something like : range("c:\myfile.xls[Sheet1]!D2") etc etc Can someone remind me how to do this? Thanks Rog . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
interrogating a workbook WITHOUT opening it from VBA
Thanks, knew i'd seen it somewhere!
ADO is good, but we don't have the latest version of ADO - we're so out of date here! -----Original Message----- Roger, Here is one method. Read the caveat at the bottom of the page carefully. http://www.j-walk.com/ss/excel/tips/tip82.htm Another method would be to use ADO to work with the Excel file directly http://support.microsoft.com/default.aspx?scid=kb;en- us;278973 Troy "Roger Butler" wrote in message ... Not sure if this was the way i read, but i found one way to do it : just write the link in to the cell directly : eg range("a1").formula ="='X:\Derivatives\[he Euronext.xls] Automate'!AF70" If anyone has a better way, please advise! Cheers Rog -----Original Message----- Hi All A few years ago i remember reading that it is possible to "get at" values stored in another workbook from VBA, without having to open that workbook. It went something like : range("c:\myfile.xls[Sheet1]!D2") etc etc Can someone remind me how to do this? Thanks Rog . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interrogating cells by cell formatting | Excel Worksheet Functions | |||
Interrogating Data in Excel | New Users to Excel | |||
Interrogating format | Excel Programming | |||
How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
How to make opening of workbook conditional of opening of another workbook | Excel Programming |