I need to pull 10 or so documents from a website every 10 minutes.
1) When these files are downloaded, they need to be merged into one file.
2) They need to be opened 'behind the scenes' along with one other Excel calculation file, Excel1
3) Part of Excel1 will be sent to Discord.
4) Repeat Step 1-3 with 6 other Excel files (Excel2, Excel3)
5) Start back at 1 ten minutes later.
More than half of this code is written already, I just need the code to pull the Excel files heedlessly from the website, combine them into one, and then open up the Excel file.
Code sample for headless pull of other data, opening of excel files in a loop, and Discord posting attached.