
June 15th, 2006, 11:10 AM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 1
Time spent in forums: 23 m 39 sec
Reputation Power: 0
|
|
|
ImportXML called 3 times
Slight problem with Application.ImportXML. When I run this command in VBA so that it gets the XML from a webpage I noticed it calls the page 3 times. Does anyone know why this happens?
My call is:
Private Sub SendMessage()
Dim MyXMLURL As String
MyXMLURL = "URL"
Application.ImportXML _
DataSource:=MyXMLURL, _
ImportOptions:=acStructureAndData
End Sub
I've set the php file to write to a text file each time it loads and you can see for yourselves that it writes to the file 3 times
URL
|