Hello,
I’ve written a script that allows me to login into a website automatically, but I am unable to export a file via the script because of the way the website is designed (It is just outside of my programming abilities).
Essentially this is what my script will do:
1. Login to the website with my credentials
2. Export the Excel CSV file and save it to a specified location with a specified name (This is where I am stuck)
3. Once downloaded, a VBA macro will run to add formulas and formatting
4. Then email the file to a specified distribution group at a specified time every weekday.
Item 1, 3 and 4 are already complete. I just need number 2.
Essentially, the website has a share button using CSS. When it is pressed, it give the option to export an excel file. When the "Export file" button is pressed, it opens a form with some simple input fields and there is a final "Export" button. There are no ID's associated with these buttons like with the website login form.
The HTML code for the button I want to press primarily is this:
<button class="ss-action"></button>
When pressed, the options are an unordered list:
- Email Notifications
- Export
I want to be able to click that Export list item which will then popup the form.
What I have tried:
I have tried everything I can think of. I am just a novice with automating the web.
Submit an article or tip