Hi, I need to extract data from a website that requires me to input the date range, such as 1st March 2018 to 31st March 2018, as well as an equipment code, such as A1, then press the excel ouput button to generate an excel workbook that contains 1 worksheet. I need to do this for multiple equipment codes such as A2, A3, A4 to get a lot of excel workbooks. In the past, I have been doing this manually but there are over 100 equipment codes so its a massive waste of time and I was hoping for a method to automate the process, maybe via VBA or VBS.
If possible, it would be best to be able to copy all the data in the workbooks to worksheets in my own workbook so that I can use a macro I have already created to analyse the data but as long as the workbooks for each equipment code are generated, I'll be very happy already.
I posted in this forum as well: http://www.vbforums.com/showth…site-that-requires-inputs