Is this progress bar possible?

[option]

Basically, I just want to make a progress meter that updates after all 4 of the following steps are done. I run a macro, then batch file, then 2 more macros. Since this process in total takes up to about 30 minutes, a progress bar would be great. I did a search and everything i found was timer related. Any thoughts or ideas?

Private Sub Command120_Click()
DoCmd.RunMacro "Data Extraction"

Call ShellWait(Environ$("COMSPEC") & " /c  x:\batfiles\getnewsourcefiles.bat", vbNormalFocus)
 
DoCmd.RunMacro "ImportData"
    
DoCmd.RunMacro "IntervalsUpdate"


End Sub

 

[sbenj69]

ooops, misread..... heh, I was posting a timer related progress bar, sorry......

 

[khawar]

Attached a simple progress meter form for you to get started

 

[option]

You guys are awesome!

Thanks a lot! My database looks great!