Hi I would like to open a webpage that displays an XML file then save the content as a local XML file.
Using the 'Import XML' feature in Access works fine to a point but everytime I use the wizard it accesses the site 3 times...The problem is that I am limited to 9 webpage accesses a week (1 a day plus 2 xtra) and I want to carry out this process 5 times a week (each weekday).
Below is some cut down code based on a form with a webbrowser control
Dim URL As String
URL = "http://www.website.com/datafeed.cgi?UserID
Me.Text3 = Me.WebBrowser2.Document.Bo
This almost works but what i really need is the content from the view source. Is this possible??
If I use Innerhtml instead of outertext I get a load of <Div> info etc.
Although the data is not included in the two wrongs and correct file I assume that the principal is the same for saving the source. I have also attached an example data file for reference.