Hi,
I have macro setup to login to a website and perform a WebQuery. There are several links that the query downloads and puts on the spreadsheet as hyperlink and users will work from this sheet using the hyperlink to get data.
One of these links is used to navigate out to see if there are any attachments the client may have uploaded for us to download. There could be 1 or a number of files to download and 9 out 10 times there is at least 1 file to download which forces us to put a fulltime employee on this. Since I have created several macros to automate daily task I have been asked to explore the possibility of automating this process.
I’m very familiar with VBA, but I’m not familiar with using it to communicate with internet explorer. With that said, below is the source code of the files that need downloaded and I was wondering if someone who is familiar with this can take a look at it and give me some code which allow me to do the following:
1. Determine the number of files that need downloaded.
2. Download the file to a directory on my computer.
If you need clarification on anything or need additional information, please let me know.
Also, does anyone know if a book or a good resource online that will help me learn how to use VBA to communicate to internet explorer?
Rick
I have macro setup to login to a website and perform a WebQuery. There are several links that the query downloads and puts on the spreadsheet as hyperlink and users will work from this sheet using the hyperlink to get data.
One of these links is used to navigate out to see if there are any attachments the client may have uploaded for us to download. There could be 1 or a number of files to download and 9 out 10 times there is at least 1 file to download which forces us to put a fulltime employee on this. Since I have created several macros to automate daily task I have been asked to explore the possibility of automating this process.
I’m very familiar with VBA, but I’m not familiar with using it to communicate with internet explorer. With that said, below is the source code of the files that need downloaded and I was wondering if someone who is familiar with this can take a look at it and give me some code which allow me to do the following:
1. Determine the number of files that need downloaded.
2. Download the file to a directory on my computer.
If you need clarification on anything or need additional information, please let me know.
Also, does anyone know if a book or a good resource online that will help me learn how to use VBA to communicate to internet explorer?
Rick