| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
get data from closed workbooks!
Hi Ron,
This is it!.. I was looking all over the place on my PC to locate an example including such a syntax. Thanks a lot. You are among my favorite excel masters on this NG. Cheers Marytn "Ron de Bruin" wrote in message ... Hi Martyn ='C:\Data\[test1.xls]Sheet1'!$A1 If you use the full path it will do what you want. Only if you open the workbook you get a dialog that ask you if you want to update the links -- Regards Ron de Bruin http://www.rondebruin.nl --- Outgoing mail is certified Virus Free. (Giden posta virüssüz olarak belgelendi.) Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 02.07.2004 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Data from Closed Workbooks | Excel Worksheet Functions | |||
| Referencing Data in Closed Workbooks | Excel Discussion (Misc queries) | |||
| Keeping data once referenced workbooks are closed. | Excel Discussion (Misc queries) | |||
| SAVING DATA TO CLOSED WORKBOOKS | Excel Worksheet Functions | |||
| Copying Data from closed workbooks | Excel Programming | |||
Threaded Mode
