We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info

[3241] API Programming Series #5

Last post 11-04-2004 9:06 PM by mistkron. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 01-01-1999 12:00 AM

    [3241] API Programming Series #5

    This thread is for discussions of API Programming Series #5.

    • Post Points: 0
  • 05-04-2003 7:14 AM In reply to

    • htckiran
    • Not Ranked
    • Joined on 05-04-2003
    • New Member
    • Points 5

    API programming series

    it cleared many doubts regarding API programming in vb
    • Post Points: 0
  • 06-02-2003 3:04 PM In reply to

    Thanks..

    Thank you for spending your time to write these great articles. They are very helpful and clearly written.
    • Post Points: 0
  • 06-05-2003 8:51 AM In reply to

    • sreejath
    • Not Ranked
    • Joined on 04-17-2002
    • New Member
    • Points 35

    Thanks

    Thank you for expressing your appreciation.
    • Post Points: 0
  • 08-24-2003 12:57 PM In reply to

    • marz
    • Not Ranked
    • Joined on 08-24-2003
    • New Member
    • Points 10

    vb and excel

    HI!

    Is there a way to transfer the database to excel rather usingt the datareport?
    If you have any suggestions or ideas pls feel free to mail me.

    thanks.
    marz!
    marz03@yahoo.com
    • Post Points: 0
  • 01-20-2004 11:57 AM In reply to

    • wayp
    • Not Ranked
    • Joined on 01-20-2004
    • New Member
    • Points 20

    MSFlexGrid to Excel

    I always do this for my "print to file" checkbox in the print dialog

    **Needed Reference** : Microsoft Excel x.y Object Library

    Code:

    Public Sub ExportFlexGrid(ByRef objGrid As MSFlexGrid)
       Dim objXL As Excel.Application
       Dim objWB As Excel.Workbook
       Dim objWS As Excel.Worksheet
       Dim r As Long
       Dim c As Long
       Dim intRed As Integer
       Dim intGreen As Integer
       Dim intBlue As Integer
       
       Set objXL = New Excel.Application
       Set objWB = objXL.Workbooks.Add
       Set objWS = objWB.Worksheets(1)

       With objWS
           For r = 0 To objGrid.Rows - 1
               For c = 0 To objGrid.Cols - 1
                   .Cells(r + 1, c + 1) = objGrid.TextMatrix(r, c)
               Next
           Next

    '   You can do some nice things, like adding a counter
    '        .Cells(objGrid.Rows, 7) = "=count(G2:G" & objGrid.Rows - 1 & ")"

           .Cells.Columns.AutoFit
       End With

       objXL.Visible = True
       
       Set objWS = Nothing
       Set objWB = Nothing
       Set objXL = Nothing
    End Sub
    • Post Points: 0
  • 11-04-2004 9:06 PM In reply to

    • mistkron
    • Not Ranked
    • Joined on 11-04-2004
    • New Member
    • Points 5

    questions..

    this is really nice article, but im wondering is there a way to display the memory status in a textbox ? well im rather new to vb.
    • Post Points: 0
Page 1 of 1 (7 items)