I am trying to read data from a .txt file and put certain data into an Excel ole chart in my VB application. Could anyone please point me in the right direction.
Many Thanks
Printable View
I am trying to read data from a .txt file and put certain data into an Excel ole chart in my VB application. Could anyone please point me in the right direction.
Many Thanks
Read the text file into an array (or whatever datastruc you want) in VB then use the Excel VBA methods by simply declaring an object as an Excel.Application - this will give you access to all Excel's methods.
I cannot give specific advice about using the charting methods 'cos I don't know Excel well enough.
Hope that helps.
Paul