VBA dialog box?

[cj92713696]

I want to use VBA using Windows Scripting that will display a dialog box, execute a program, and then after the program is executed, remove the dialog box.

I have an auditing program that takes like 3 minutes to run, and once a month, I want to have a VBA script call the modal form, then my batch file execute the audit.exe program, then the VBA script remove the modal form. Can someone help me w/this or is there a better way to do this?

Thanks a lot,
Charles Sperber

 

[scking]

I assume you would use the Windows Scheduler to set up a monthly run of the script. Windows scripting could be used to display a message box and give you buttons to select what you wanted to do, but if you wanted any other type of form you would probably need to either build it into you audit.exe application (if possible) or use some other tool to build the user interface for the form.

Unless you want the script to do something special, like logging the run to a logfile, the easiest solution is to just use the Windows Scheduler to schedule a monthly run for your audit.exe application.

Steve King Growth follows a healthy professional curiosity