Excel and VB

I am currently trying to write a VB program involving an array of data from a test bench
using a oscilloscope and GPIB with a GUI in VB6.

I need to save the array of data to a file (GUI Save as file) and then automatically open a Excel graph which will transfer the data to a graphical representation ?

Do i need to write a Macro for the Excel program ?

Does anybody have any suggestions as my VB programming is very poor !

Thank you !

[André]

Hi there, you can actually work directly with excel from VB. Excel is COM, so you can use it in your application. I'm not an expert but you create the excel object and use its methods and properties to do whatever you want to. Try searching VB and Excel on Altavista or the microsoft.com search.

Good luck,

André