PDA

View Full Version : How to change cell data in excel by reading data from another file



fuze
03-29-2009, 11:25 AM
I need to create a programme that will read data from a file and use that data to change cells in excel.

I am trying to create something that will allow me to change excel cell data live by dragging a mouse up and down, using puredata and visual basic.

For the visual basic I need it to read data from a file of some sort (havent worked out what type of file yet) on a loop and input that data into a specific cell in excel, so that when i drag the mouse, puredata changes the value in the file and vb reads this and inputs the data into excel so that the cells and my graph changes as a result.

If anyone can help thank you very much!

All the best