<div>
because Word does not trigger events when running a macro, you cannot have a progress bar (you don't know for how long the macro will run and how much time for ending).
</div>


because Word does not trigger events when running a macro, you cannot have a progress bar (you don't know for how long the macro will run and how much time for ending).

<div>
emoreau is right and so all you can do is report to the best of your knowledge what is taking place according to your code's execution... anything else would just be some &quot;made up stuff&quot;.
</div>


emoreau is right and so all you can do is report to the best of your knowledge what is taking place according to your code's execution... anything else would just be some "made up stuff".

<div>
<div class="content wysiwyg-content">
I'm using VB6 against an SQL Server database.<br />
I have a form which has several selections and a command button which the user launches a word macro based on these selections.<br />
The word macro will launch an instance of Microsoft Word and generate a report based on the user selections.<br />
Sometimes if the report is large, it takes a while for Word to popup.<br />
I added a &quot;Processing...Please Wait....&quot; to the Caption to inform the user.<br />
I'd like to add a ProgressBar to let them know that word is busy in the background.<br />
I don't have a recordset to loop thru so I can't show them the progressbar processing on the from so is there another way to do this; possibly with a timer.<br />
<br />
Also, if anyone knows of other ways to inform the user of a wait state, I'd appreciate it.<br />
<br />
Thanks in Advance<br />
John <br />

</div>
</div>


I'm using VB6 against an SQL Server database.
I have a form which has several selections and a command button which the user launches a word macro based on these selections.
The word macro will launch an instance of Microsoft Word and generate a report based on the user selections.
Sometimes if the report is large, it takes a while for Word to popup.
I added a "Processing...Please Wait...." to the Caption to inform the user.
I'd like to add a ProgressBar to let them know that word is busy in the background.
I don't have a recordset to loop thru so I can't show them the progressbar processing on the from so is there another way to do this; possibly with a timer.

Also, if anyone knows of other ways to inform the user of a wait state, I'd appreciate it.

Thanks in Advance
John 


ProgressBar While Waiting For Word Macro

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.