Copying live data from one copy of excel to another - please help.

[Mightyginger]

I have 2 copies of excel open on one machine. One has spreadsheet "master" open and it calculates prices, the second one "slave" needs to have these linked live prices constantly updated. I don't want to open both workbooks in the same copy of excel because of the chance of it crashing so it has to be set up this way. My question is what is the easiest way to get the live prices into a workbooks in one copy of excel from a workbook open on the same machine but running a different workbook.

Any advice would be appreciated.



Neil.

 

[Bowers74]

Something like this will copy the entire sheet's content's from one workbook to a specific sheet's range (A1) in another:

Workbooks("Slave.xls&quot.Sheet1.cells.copy Destination:=Workbooks("Master.xls&quot.Sheet1.Range("A1&quot

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Mightyginger]

Thanks Mike but the problem is that they're open in DIFFERENT copies of excel. So that code won't work. At the moment I'm just writing a bit of code to dump the prices to a database everytime the sheet is recalculated and the other excel reads in the prices from the database.

 

[xlbo]

Summat like this should get you going - you would put this in the "master" workbook:

Dim ObjExcel As Excel.Application
Set ObjExcel = GetObject(, "Excel.Application&quot
With ObjExcel
With Workbooks("Slaveworkbookname&quot.Sheets("SheetToPutDataIn&quot
.Range("A1&quot.Value = ThisWorkbook.Sheets("SheetToPullDataFrom&quot.Range("A1&quot.Value
End With
End With

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Bowers74]

OK, I'm lost . . . Did you even try it?





Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[xlbo]

Sorry Mike but I get a subscript out of range error with your code

Rgds, Geoff
[blue]Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?[/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244