Thread: Read/Write from/to a closed workbook

Using a macro, how can I write the value from
Workbooks("Wb1").Range("Rng1") to Workbooks("Wb2").Range("Rng2") when
"Wb2" is closed?

Conversely, how can I read the value from
Workbooks("Wb2").Range("Rng2") into Workbooks("Wb1").Range("Rng1") when
"Wb2" is still closed?

I don't want to use links because I need complete control over the
event and I need to pass data in both directions.

Look at the thread in this NG from 11 June:
Problem with file finding macro.

RBS

"Alan" <alan.dowen@virgin.net> wrote in message
news:1150193006.621755.228540@y43g2000cwc.googlegroups.com...
> Using a macro, how can I write the value from
> Workbooks("Wb1").Range("Rng1") to Workbooks("Wb2").Range("Rng2") when
> "Wb2" is closed?
>
> Conversely, how can I read the value from
> Workbooks("Wb2").Range("Rng2") into Workbooks("Wb1").Range("Rng1") when
> "Wb2" is still closed?
>
> I don't want to use links because I need complete control over the
> event and I need to pass data in both directions.
>

that really isn't supported unless your range is organized like a database

If it is, you can treat the file as a database and use ADO


http://www.erlandsendata.no/english/...php?t=envbadac
--
Regards,
Tom Ogilvy



"Alan" wrote:

> Using a macro, how can I write the value from
> Workbooks("Wb1").Range("Rng1") to Workbooks("Wb2").Range("Rng2") when
> "Wb2" is closed?
>
> Conversely, how can I read the value from
> Workbooks("Wb2").Range("Rng2") into Workbooks("Wb1").Range("Rng1") when
> "Wb2" is still closed?
>
> I don't want to use links because I need complete control over the
> event and I need to pass data in both directions.
>
>

Tom, if the range is a single cell can I do it then? And if so, how??

Thanks,

Tom Ogilvy wrote:
> that really isn't supported unless your range is organized like a database
>
> If it is, you can treat the file as a database and use ADO
>
>
> http://www.erlandsendata.no/english/...php?t=envbadac
> --
> Regards,
> Tom Ogilvy