Hello,
I'm trying to load an XML from the web to an object in VBA, it works on every machine exapt one (my server).
This is the code:
on every machine the last line of code (XmlObject.Load (URL)) in the "Locals Window" the relevant properties are full, on this specific machine its all empty.
same office 365 on all machines.
what do you think could be the problem ?
thank you.
I'm trying to load an XML from the web to an object in VBA, it works on every machine exapt one (my server).
This is the code:
VBA Code:
Dim URL As String
Dim XmlObject As Object
Set XmlObject = CreateObject("MSXML2.DOMDocument.6.0")
URL = "https://old.cbs.gov.il/reader/pirsum_madad/indices_heb.xml"
XmlObject.async = False
XmlObject.Load (URL)
'the code continue.....
on every machine the last line of code (XmlObject.Load (URL)) in the "Locals Window" the relevant properties are full, on this specific machine its all empty.
same office 365 on all machines.
what do you think could be the problem ?
thank you.