Hi, I need to create a programme that will read data from a file and use that data to change cells in excel, and I was wondering if anyone can help me.
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.
I have attached a picture of the file I am trying to do it with.
It is for use in an interactive presentation. The use in my example is for selling a marketing proposal to a customer.
The chart on the left shows the quantities of units in the proposal and the chart on the right shows the cost, with the total cost underneath.
I want to be able to drag the quantities with the mouse and use puredata tol read the sursor position and change the particular data in the file for vb to read from and change the cell value
For example if flyer quantities is at x36, y24 on the grid, when i move y24 to y26 pure data would input the data change from 4 to 5 in the file, then vb would read this change and input 5 into the cell value, thus changing the spreadsheet and the quantity chart on the left, and the cost chart on the right. That is why I need the vb programme reading the data on a loop, so whenever it changes in the file, vb changes the value in excel.
I can work on getting puredata to do that part of it, I just have no idea how to get visual basic to do the rest
I hope that is explained clear enough, thank you very much in advance!
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.
I have attached a picture of the file I am trying to do it with.
It is for use in an interactive presentation. The use in my example is for selling a marketing proposal to a customer.
The chart on the left shows the quantities of units in the proposal and the chart on the right shows the cost, with the total cost underneath.
I want to be able to drag the quantities with the mouse and use puredata tol read the sursor position and change the particular data in the file for vb to read from and change the cell value
For example if flyer quantities is at x36, y24 on the grid, when i move y24 to y26 pure data would input the data change from 4 to 5 in the file, then vb would read this change and input 5 into the cell value, thus changing the spreadsheet and the quantity chart on the left, and the cost chart on the right. That is why I need the vb programme reading the data on a loop, so whenever it changes in the file, vb changes the value in excel.
I can work on getting puredata to do that part of it, I just have no idea how to get visual basic to do the rest
I hope that is explained clear enough, thank you very much in advance!
