Hi,
What i need is to hook up VB.Net 2005? to Excel 2003.
I need to monitor a cell in Excel and when the value of this changes then load this value into a fixed length array in [login to view URL] form. ie
sub Form 1
Array(i)=excelvalue
i=i+1
end sub
I would like this to be done with a hard coded excel sheet in the code, say in the C: drive.
The value of the cell changes rannomly so a timer is no good, it would need to be in some sort of event.
Thanks