Communicating with other .... Thanks Dave!

[Legacy 98055]

Hey!

What is the syntax in VBA for posting/ retrieving data from another open workbook?

In this example I would like C:wba.xls to send the value from sheet1.range("A1") to C:wbb.xls sheet1.range("B1")

Both workbooks are open...

Thanks for the help!

Tom
This message was edited by TsTom on 2002-03-25 01:08
This message was edited by TsTom on 2002-03-25 01:27

 

[Dave Hawley]

Hi Tom

Modify this to suit:

Workbooks("Book5.xls").Sheets("Sheet1").Range("B1") = _
Sheet1.Range("A1")

 

[Legacy 98055]

Thanks Dave