Excel VBA - Change cell value in another excel window

Asked Jan 24 '13 at 10:45

Active Jan 24 '13 at 11:06

Viewed 58 times

Possible Duplicate:
Can VBA Reach Across Instances of Excel?

Is it possible to change a cells' value in another excel file (open in separate window) via vba in the first window?

I am currently using a pasted link but this doesn't trigger a 'Change Event'

Thanks.

edited May 23 '17 at 10:34

Community

asked Jan 24 '13 at 10:45

user2007124

1

So you have two separate instances of excel and you want to change a cell in one from the other? – bonCodigo Jan 24 '13 at 10:48
Hi. Yes thats what I'd like to do. – user2007124 Jan 24 '13 at 10:50
1

Is it possible to open the separate file in the same workbook? – brettdj Jan 24 '13 at 11:10
That's best if OP can do. Just open both files and then all good. But if not see here http://stackoverflow.com/questions/2971473/can-vba-reach-across-instances-of-excel – bonCodigo Jan 24 '13 at 11:18
Dual monitors is the reason for two instances. I will look into it bon, thanks. – user2007124 Jan 24 '13 at 11:31
Do you know the name of the other file which is opened in the other instance? – Siddharth Rout Jan 24 '13 at 13:19

0 Answers0