Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Sirs,
I am trying to download a csv file from the internet using the MSHTML model and can successfully obtain the data to a HTMLDocument variable using the following. Dim objMSHTML As New MSHTML.HTMLDocument Dim objDocument As MSHTML.HTMLDocument Set objDocument = objMSHTML.createDocumentFromUrl (txtURL.Text, vbNullString) where txtURL.Text = "http://www.a_web_site.com/download/data.csv" What I cannot do is extract the csv data from the variable, as it does not appear to be associated with any node / element etc. I know the objDocument does contain the data as I can check the size of the variable to which it returns a largeish value I am really quite lost with all this - I do not really understand how all this works and have been trying to find an online resource that explains it in lay terms, however everything that I have located to date goes way over my head! Hoping someone can assist Regards Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OLE Objects | Excel Discussion (Misc queries) | |||
VBA Objects | Excel Discussion (Misc queries) | |||
Dynamically Assign Objects to Form Objects. | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
deleting objects using VBA | Excel Programming |