not really.
not really.
As long as this is the method you are using to export the data, no ProgressBar will help because it will never have any CPU time to update.
so what would be your suggestion so I can use the progressbar.
Can you try this where you are now to see if there is any difference in the time taken?
Code:Private Sub exporting_click() docmd.OutputTo acOutputQuery ,"Accounts",acformatxls,"C:\Account.xls",False End Sub
Have you looked into the TransferSpreadsheet Method yet? It can export.
Something like:
DoCmd.TransferSpreadsheet acExport,,"Accounts,"C:\Account.xls"