Yesterday I asked a question regarding how to regex out a multiline paragraph from a html source.
Today I have found a new and better approach to my probable.
This new approach involves getting an exported .CVS File. This file contains the information I need.
I have no problems navigating through the file once we figure how to download it.
You may be thinking why not use this:
Dim XLocation As String = CStr("http://www.MyClientsWebsite.com.au/agentdesktop/export/csv?type=Residential&agent=all&&order_by=CREATED_DESC") ' As you can see this is not a direct file location.
My.Computer.Network.DownloadFile(XLocation, (CurDir.ToString.TrimEnd("\") & "\source.cvs")) ' downloads XLocation to the current directory and names the file source.cvs
The website requires a user to login to it.
I am using a Webbrowser control to login and navigate through the site.
This is why I think the .DownloadFile function will not work because of the session or something.
The whole idea of my project is automation in the background.
Maybe I could just navigate to it and IDK well that would defeat its job of automation everything in the background.
Any help or advice is much appreciated.
EDIT 2013-3-21 3:40PM
I think the issue is with the sessions and cookies or something.
Is there a way to grab the session from the WebBrowser contol and use that with the Network.DownloadFile function you see above???