Communicating with other .... Thanks Dave!

Tom Schreiner · Mar 25th, 2002, 02:06 AM

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 · Mar 25th, 2002, 02:23 AM

Hi Tom

Modify this to suit:

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

Tom Schreiner · Mar 25th, 2002, 02:26 AM

Thanks Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 02:06 AM	#1
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]

Mar 25th, 2002, 02:23 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Tom Modify this to suit: Workbooks("Book5.xls").Sheets("Sheet1").Range("B1") = _ Sheet1.Range("A1")

Mar 25th, 2002, 02:26 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Thanks Dave