Home > IT Answers > Development > Showing progress bar form during QueryTables
webluca
60 pts.
 Showing progress bar form during QueryTables
Excel VBA, VBA functions
Hi, I'd like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I'm using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.

Software/Hardware used:
VBA Excel Oracle
ASKED: October 1, 2012  10:14 AM
UPDATED: October 1, 2012  11:41 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What is the measure of ‘progress’ that you want to show? How will you keep track of the ‘progress’ so that you know how much of the progress bar to show? — Tom

TomLiotta
 108,055 pts.
 

The best will be if the progress bar can show the total time and the elapsed time: I can calculate the record count an evaluate the average time per record.Anyway ite is enought to have a bar that increase every second and at the end of the bar it starts from the beginning.I trid this with a timer, but I have some problems whit the DoEvent, maybe I don’t understan how it works…

webluca
 60 pts.
 

Dear findaburke I don’t need a friend right now, just an answer to my question. If I need for a friend I go in IT friends exchange, not in IT knowledge exchange, do you?

webluca
 60 pts.