A
Antonio
The following code successfully opens a workbook and runs a method in that
workbook
Sub OpenAPS()
Const wb = "C:\Ats\Excel\APS.xls"
Workbooks.Open (wb)
Range("Server").Value = "abc1"
Application.Run ("APS.xls!Sheet4.subscribe")
End Sub
However, if I add more code after the Application.Run line the new code is
not run or, the APS.xls!Sheet4.subscribe method is not fully executed, which
leads to errors.
For example in
Sub OpenAPS()
Const wb = "C:\Ats\Excel\APS.xls"
Workbooks.Open (wb)
Range("Server").Value = "abc1"
Application.Run ("APS.xls!Sheet4.subscribe")
Call GetData
End Sub
The GetData sub is not executed.
The APS.xls!Sheet4.subscribe method takes a few seconds to execute fully.
I don't know if the reason is that the Call GetData is run before the
APS.xls!Sheet4.subscribe is run fully.
If so, how can I force a method to run only after a previous one is exited?
If that is not the reason, what is?
Thanks,
Antonio
workbook
Sub OpenAPS()
Const wb = "C:\Ats\Excel\APS.xls"
Workbooks.Open (wb)
Range("Server").Value = "abc1"
Application.Run ("APS.xls!Sheet4.subscribe")
End Sub
However, if I add more code after the Application.Run line the new code is
not run or, the APS.xls!Sheet4.subscribe method is not fully executed, which
leads to errors.
For example in
Sub OpenAPS()
Const wb = "C:\Ats\Excel\APS.xls"
Workbooks.Open (wb)
Range("Server").Value = "abc1"
Application.Run ("APS.xls!Sheet4.subscribe")
Call GetData
End Sub
The GetData sub is not executed.
The APS.xls!Sheet4.subscribe method takes a few seconds to execute fully.
I don't know if the reason is that the Call GetData is run before the
APS.xls!Sheet4.subscribe is run fully.
If so, how can I force a method to run only after a previous one is exited?
If that is not the reason, what is?
Thanks,
Antonio