Complete VBA code for a web query to extract data from online database
We require someone to complete VBA programming to extract external data from a web-app called Vend (see vendhq.com)
I now have VBA code (about 50 lines) that
1. opens explorer
2. selects the appropriate database in Vend
3. copies the data required
4. pastes the data into excel
5. cleans up the formatting in excel
6. logs out of the database
But, there are still some problems with toggling between different "registers" in Vend and pasting the data for each register into different sheets in spreadsheet.
We also need the VBA to loop every five minutes, and to close the internet explorer window at the end of each loop.
I also need to be confident that the code is stable, and we will need to have alerts set up in the event the code fails.
We will also need some code to send email alerts when a certain condition is satisfied (e.g. sales over the last hour are 10% higher than average (I can set up the conditions, but I do not know how to write the code to send out an alert when they are satisfied)
If you are interested please give me a quotation.