Results 1 to 2 of 2

Thread: VB 5.0 and Excell

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Blackpool
    Posts
    14

    Post

    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

  2. #2
    Guest

    Post

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width