Hi All,
I've hit a bit of a roadblock as there are Text files that reside on a SharePoint drive that I initially was trying to download using the method below
Set req = CreateObject("Msxml2.XMLHttp.6.0")
req.open "GET", url, False
req.send
Problem is there is security that is preventing this from happening and there's no way I can get it lifted. I can navigate to a webpage to show the contents of the text file inside a webpage but I'm still struggling in trying to get all the text off of it so I can save it to a local file. I know it's probably not going to be pretty given that the above didn't work, I was hoping to store the documentElement as a variable and had no luck and even resorted to trying to do sendkeys commands of Select all/copy and that hasn't worked so far.
So my question is, if I have webpage that is able to open a text files contents on it what is the best alternative route to trying to scrape that text off the page?
Thanks in advance for any help provided!
I've hit a bit of a roadblock as there are Text files that reside on a SharePoint drive that I initially was trying to download using the method below
Set req = CreateObject("Msxml2.XMLHttp.6.0")
req.open "GET", url, False
req.send
Problem is there is security that is preventing this from happening and there's no way I can get it lifted. I can navigate to a webpage to show the contents of the text file inside a webpage but I'm still struggling in trying to get all the text off of it so I can save it to a local file. I know it's probably not going to be pretty given that the above didn't work, I was hoping to store the documentElement as a variable and had no luck and even resorted to trying to do sendkeys commands of Select all/copy and that hasn't worked so far.
So my question is, if I have webpage that is able to open a text files contents on it what is the best alternative route to trying to scrape that text off the page?
Thanks in advance for any help provided!
