Want to display a progress bar until message box appears

[ExSellerate]

I’m using an add-on for ACT! that merges data from contact fields into an Excel File. The operation takes several seconds and when it’s complete a message box is displayed (title:” Excel Quote-Invoice Maker”) indicating that the operation is complete. I’ve written a small script that automates the process and it works, but I’d like to display a progress bar until the message box appears.

Sounds easy enough? Here’s my script:

;Make sure ACT! is on top
WinActivate("Sage ACT! Premium - LRE")
Sleep(100)

; Prompt the user to run the script - use a Yes/No prompt
$answer = MsgBox(4, "LRE Merge Pier Installation Log ", "Do you want to create a Pier Installation Log and attach it to this Contact Record?")

; Check the user's answer to the prompt If "No" was clicked (7) then exit the script
If $answer = 7 Then
    MsgBox(0, "Cancel LRE Merge", "No changes have been made to the contact record")
    Exit
EndIf

;Launch Exponenciel "Excel Quote-Invoice Maker" Addon
Send("!t")
Sleep(100)
Send("{UP}{UP}{UP}{UP}{UP}{ENTER}")
Sleep(100)
Send("{RIGHT}{RIGHT}{ENTER}")
Sleep(100)
Send("{ENTER}")

;I want to add a progress bar until this window appears:
WinActivate("Excel Quote-Invoice Maker")

[wakillon]

See ProgressOn, ProgressSet, ProgressOff Functions.

and increment progress to each step of your script !