API Excel Chart HELP ME PLEASE!!!

[daniel wilde]

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

[paulw]

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