Showing progress bar form during QueryTables

60 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • webluca
    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...
    60 pointsBadges:
    report
  • webluca
    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?
    60 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following