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.