CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 8 of 8

Threaded View

  1. October 15th, 2009, 09:36 PM #1
    George1111
    George1111 is offline Senior Member
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,901

    When a machine slows down ...

    I have a process which selects data from an Access database, organises it, then populates some Excel worksheets

    This has always been a reasonably slow process but lately it has become slower and slower

    Take 2: ....

    The SQL Selections and opening of the Excel Objects are not the big bottle necks


    The big delay occurs when I populate the Excel Form with a large number of items

    eg,

    Code:
    msExcelWorksheet.Cells(SheetRow, SheetCol) = StockCode
    I know Excel is not a Flexgrid, but I can recall the joy when I discovered FlexGrid.Redraw = False (which speeded things up incredibly)

    Appreciate any ideas
    Last edited by George1111; October 15th, 2009 at 10:32 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured