VB 5.0 and Excell

[SteFlitII]

Can anyone suggest the best way in which I can save data be it from a text file, ado recordset, or whatever source to an Excel spreadsheet. Do I have to open an instance of a spreadsheet or a workbook ??? I'm confused. Any help greatly appreciated
Steve
VB Programmer
[email protected]

Steve,

Try

Shell Chr(34) & "C:\Program Files\Microsoft Office\Office\Excel.exe" & Chr(34) & " C:\Log.txt", vbNormaFocus

this code opens up log.txt within excel
hope this helps
V