Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PetersBase
-
VBA multi thread Progress Bar
Hi Tony, Yes my VBA process does "sit and wait" until the Query has finished, then my code drops the results into a spreadsheet. I guess I will have to use a large MessageBox saying "Please wait ... processing", then close it when the Query is done. I believe it's fairly easy to "talk" between...- PetersBase
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA multi thread Progress Bar
Hi Tony, Thanks for your reply. I think I'm in situation number 3, "You fire off a process for which VBA waits. There is no multi-threading and there is nothing you can do in this case because your VBA doesn't get control". The long running process I have is a SQL query on a Server I have...- PetersBase
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA multi thread Progress Bar
Hi Experts, I've spent many days searching on the internet for an answer to the following problem: Using VBA in Excel, start a time consuming task such as an SQL query. While this task is underway, start a Progress Bar that increments with a preset time interval. When this bar reaches the...- PetersBase
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
