ShellExecute via VB to Excel
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: ShellExecute via VB to Excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    My vb code utilizes the FarPoint(2.5.40) spread control which I load the ResultSet.Fields(i).name and ResultSet.Fields(i).values. When I execute the following code( bSave = vaSpreadResults.SaveTabFile("C:TEMPConstructionAnalysis.xls"))
    and ShellExecute to excel, I only get the values and want to also get the column names displayed? How can I accomplish this?

    Thanks

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Heres the fix I made fyi:
    Instead of loading the farpoint spread
    row 0 with rs.fields(i).name I load it to
    row 1, all subsequent rows in rs increment
    from row 2 forward. This allows the export
    to excel to utilize the SaveTabFile and shell out to excel displaying the headers
    followed by values.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com