Re: get data from closed workbooks!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Martyn (eser_at_cc.emu.edu.tr)
Date: 07/03/04

Next message: Edward S: "Distributing All Days Across Months by CPearson"
Previous message: RDBrimmer: "Auto Slate Excel File"
In reply to: Ron de Bruin: "Re: get data from closed workbooks!"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 3 Jul 2004 10:28:03 +0300

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" <rondebruin@kabelfoon.nl> wrote in message
news:#l9wTrCYEHA.2868@TK2MSFTNGP09.phx.gbl...
> 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

Next message: Edward S: "Distributing All Days Across Months by CPearson"
Previous message: RDBrimmer: "Auto Slate Excel File"
In reply to: Ron de Bruin: "Re: get data from closed workbooks!"
Messages sorted by: [ date ] [ thread ]