PDA

Click to See Complete Forum and Search --> : VB 5.0 and Excell


SteFlitII
Jan 12th, 2000, 12:08 AM
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
Steveflit@aol.com

Jan 13th, 2000, 05:08 PM
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