Here is the solution I found by using VBA (to control Edge browser) and the Task Scheduler (to automatically open the file with macro at a giver time).
To run the macros for
automatic extractions from SAP, the computer needs:
·
Selenium Library (for VBA)
·
Microsoft .NET Framework 3.5
1. Install the Selenium Library
1. Download the Selenium Basic v2.0.9.0
with this link.
2. Execute the downloaded file, it
should be named “SeleniumBasic-2.0.9.0.exe”.
3. Click on “Next”.
4.
Select “I accept the
agreement” then click on “Next”.
5.
Click on “Next”.
6.
Click on
“Install”. Once the installation is done, close the window.
7.
Search in
the Windows Search Bar “%AppData%” and press “Enter”. In the window that pops
up, click on “AppData”.
8.
Click on “Local”.
9.
Click on
“SeleniumBasic”.
10.
Delete the
“edgedriver.exe” file, it’s expired.
11.
Go to Edge Settings
and click on “About Microsoft Edge”.
12.
Check the Edge
version.
13.
With this link, find the drivers list of the
release corresponding to the Edge version and select the select the “x86” version
of the first driver in the list.
14.
Open the
downloaded folder, rename the “msedgedriver.exe” file into “edgedriver.exe” and
copy-paste it in the SeleniumBasic folder.
2. Install Microsoft .NET
Framework 3.5
1.
Download Microsoft .NET Framework 3.5 with this link.
2.
Ask the IT department to install it as an administrator account is
required.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.