Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Waiting Mode when query data from Db via VBA!
I need to query data from DB via VBA in Excel. This step will costed a few of
seconds. End-User will only wait for result without action. Maybe this time of this section may be long time. Does VBA provide a way to pop-up a window which included some message to notice End-User the programmer is running. For example, When I click a button which query data from DB, a window will appear with no buttion, it will disappear automatically when the data is retrieved. -- Developer QA Dashboard Microsoft China Development Centre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Waiting Mode when query data from Db via VBA!
This may help:
http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... I need to query data from DB via VBA in Excel. This step will costed a few of seconds. End-User will only wait for result without action. Maybe this time of this section may be long time. Does VBA provide a way to pop-up a window which included some message to notice End-User the programmer is running. For example, When I click a button which query data from DB, a window will appear with no buttion, it will disappear automatically when the data is retrieved. -- Developer QA Dashboard Microsoft China Development Centre |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Waiting Mode when query data from Db via VBA!
Why is the version lewer 9? Can this code run on Excel 2003? but I can't get
any impact in Excel 2003. Do you offer more help ? "Robin Hammond" wrote: This may help: http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... I need to query data from DB via VBA in Excel. This step will costed a few of seconds. End-User will only wait for result without action. Maybe this time of this section may be long time. Does VBA provide a way to pop-up a window which included some message to notice End-User the programmer is running. For example, When I click a button which query data from DB, a window will appear with no buttion, it will disappear automatically when the data is retrieved. -- Developer QA Dashboard Microsoft China Development Centre |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Waiting Mode when query data from Db via VBA!
Not sure what you have done, but if you downloaded the right file you can
run the prog bar demo. Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... Why is the version lewer 9? Can this code run on Excel 2003? but I can't get any impact in Excel 2003. Do you offer more help ? "Robin Hammond" wrote: This may help: http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... I need to query data from DB via VBA in Excel. This step will costed a few of seconds. End-User will only wait for result without action. Maybe this time of this section may be long time. Does VBA provide a way to pop-up a window which included some message to notice End-User the programmer is running. For example, When I click a button which query data from DB, a window will appear with no buttion, it will disappear automatically when the data is retrieved. -- Developer QA Dashboard Microsoft China Development Centre |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Waiting Mode when query data from Db via VBA!
I have done it, thank for your help! "Robin Hammond" wrote: Not sure what you have done, but if you downloaded the right file you can run the prog bar demo. Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... Why is the version lewer 9? Can this code run on Excel 2003? but I can't get any impact in Excel 2003. Do you offer more help ? "Robin Hammond" wrote: This may help: http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "Microlong" wrote in message ... I need to query data from DB via VBA in Excel. This step will costed a few of seconds. End-User will only wait for result without action. Maybe this time of this section may be long time. Does VBA provide a way to pop-up a window which included some message to notice End-User the programmer is running. For example, When I click a button which query data from DB, a window will appear with no buttion, it will disappear automatically when the data is retrieved. -- Developer QA Dashboard Microsoft China Development Centre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
Break Mode query | Excel Programming | |||
waiting for data refresh before continuing VBA sub | Excel Programming | |||
Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming |