My program will run and call Step 1 (below)
Sub Step1()
Call GetMasterList
Call GetUnschedMaster
………
This will then call the sub “GetMasterList”
Sub GetMasterList()
Dim FileName As String
FileName = ""
Response = MsgBox("Locate Master Work Order List For This Week.", vbOKOnly,
"Master Work Order List")
FileToOpen = Application _
.GetOpenFilename("Excel Files (*.xls), *.xls")
If FileToOpen = False Then
Call Cleanup_Toolbars
frmRunStyle.Show
Exit Sub
End If
………
If the following portion of the above code is executed:
If FileToOpen = False Then
Call Cleanup_Toolbars
frmRunStyle.Show
Exit Sub
End If
Then the program will do some functions and eventually return to a start
point.
If the user then goes through the steps and gets to sub Step1 again, it will
immediately jump to
Call GetUnschedMaster
How do I get it to rerun the Call GetMasterList????
Thanks !
SS
Bookmarks