your post is a little confusing:-
>I want to read from a text file and populate a
excel file
>If possible
without using excel
but here goes(very simplified):
first you need the excel object library.
project->reference->microsoft excel x.x object library (9.0 for office 2000 i think)
you declare the excel object simply as
dim withevents MyExcelObject as excel.application
to write values to cells
MyExcelObject.Workbooks.Add
MyExcelObject.Cells(4, 8) = "hello there"
MyExcelObject.Visible = True
obviously theres plenty of code ive not put in but this should set you on your way.
if your looking to just create the excell file: the following site was referenced in another thread (not looked at it so i dont know if its any good)
as for graphs ive still not figured out how to stick a graph in vb other than using microsoft excel chart insertable object.
hope this gets you started and good luck