Run a web page

[stapuff]

Is there a way to run ( for lack of a better term) a .php webpage then close it when completed?

Thanks,

stapuff

 

[stapuff]

Might help if I ask the right question:

I have the following code that opens IE, runs a .php file, then closes IE. The question I have is how can I tell if the .php file runs completely before it is closed?

I my case the open, run, close is so fast I can not tell if it actually ran and I do not want to build in anything that will stop the macro to show me it actually is running.



Sub Button1_Click()

Dim IeApp As InternetExplorer
Dim strURL As String
Dim IeDoc As Object
Dim i As Long

Set IeApp = New InternetExplorer
IeApp.Visible = True

strURL = "myURL/time.php"

IeApp.Navigate strURL

Do
Loop Until IeApp.ReadyState = READYSTATE_COMPLETE

Set IeDoc = IeApp.Document

IeApp.Quit

End Sub

 

[John_w]

The question I have is how can I tell if the .php file runs completely before it is closed?

The standard things I do when developing code are: Step through the code in the VB debugger (F8 etc.); set breakpoints (F9); add Debug.Print statements.

For your web page, you might need to wait until the HTMLDocument is complete, like this:

While IeApp.Document.ReadyState <> "complete"
    DoEvents
Wend

 

[stapuff]

John - I appreciate the response.

I have already added that code........I was trying to verify the code did not blow through without the website page completing......in order for me to make sure...I am adding a functionality to push data to a test database to verify.

Thanks,

stapuff