w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Most Efficient Way To Export Access 2003 Listbox RowSource (query) To Excel 2003

Try generating a XML file. Here an example: http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx

P.S. About first method. To avoid users clicks you can hide Excel. Also you can speed up Excel (see functions below). Use Prepare() before putting data and Ended() after it or in case of error.

Public Sub Prepare()
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Application.EnableEvents = False
    ActiveSheet.DisplayPageBreaks = False
    Application.DisplayStatusBar = False
    Application.DisplayAlerts = False
End Sub

Public Sub Ended()
    Application.ScreenUpdating = True
    Application.Calculation = xlCalculationAutomatic
    Application.EnableEvents = True
    ActiveSheet.DisplayPageBreaks = True
    Application.DisplayStatusBar = True
    Application.DisplayAlerts = True
End Sub

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.