Change cell value in another excel window from first window

Hi all,

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.

You need to be a bit more specific. If you want code in one workbook to change the values of cells in another open workbook then yes you can do that:

Windows("Name of other workbook.xls").Activate

Ant

Or alternatively

Workbooks("Name of other workbook.xlsm").Activate

Thanks Ant.
I should have mentioned, the two sheets are in separate instances of excel. Should the above code still work?

I might be being stupid here, but when you say 'seperate instances' do you mean seperate workbooks? If so, then both of those lines will activate your other workbook provided it is open (the second line is probably better though). If it isn't open then you would need something like

workbooks.open "filepath\name of other workbook.xlsm"

to open it first.

Not at all. By 'separate instances' I mean having two Excel program windows open. I could open both workbooks in one window, but I wanted to make use of dual monitors.

Oh right, in that case I'm not completely sure but i would think

Workbooks("Name of other workbook.xlsm").Activate

should still work. I suppose the best thing to do is just stick that line of code in a procedure by itself, open up the second workbook and test it out.