Call VBA on that is located on a website

Hi Experts,

I have this code below that works perfectly when filepath and filename is located on my PC ("c/test.docm" etc..).

Now that i have stored the files on a server "http://espace.int.test.ca/workspaces/vbProject/" I can not get it to pull the file.

Please explain what i am doing wrong.

Please Login or Register  to view this content.

This is completely different then looking at your local files

-first thing is add the reference tools to allow you go online
from VB editor TOOLS--> References
scroll down until you find "Microsoft Internet Controls" and "Microsoft HTML Object Library" and check them both

- second thing you'll need to do is open the web page. The below code will Get you there.

Once your online, you'll need to use the source code to find the elements you want to interact with. If you google "VBA WebScrapping" you should come up with some example that will help.

Please Login or Register  to view this content.

There are two steps, first you need to download the file, then you can run the code as normal (you just need to substitute the file path to the location of the place you've downloaded the document). To download the file, you simply need this http://www.cpearson.com/excel/downloadfile.aspx

@steve, automating ie best avoided, especially for something as trivial as downloading a file - it's very slow and inefficient

Thanks Kyle, I dont down load much using Excel, but I've book marked your link in case i need to in the future.