Archive: Excel VBA tool to extract HTML table from password protected website
Budget
33$
per month
Posted: 5 years ago
Closed
- Description
- I need an Excel VBA macro to extract the content of an HTML table from a password protected website and insert to a new Excel sheet. The webpage only contains the table and nothing else. The password must be hidden for the users and ideally the website opens then closes in the background as users should not see the content. (the content inserted to Excel will be deleted by another macro after completing the calculations)
Before applying this job, DO CHECK THE WEBSITE as its protection seems to be a bit trickier than usual. The free tools available online failed to do the job so as a previous freelancer, hired for this exercise. After the completion the tool will be used on a different site with a different password.
The website: https://c3dsolutions.wixsite.com/htmltable
The password: xoxoxo
Of course the content and the number of rows of the table may change time to time. Only apply the job if you are sure you can complete it. I need a final solution by the end of the month.
Skills:
extraction,software development,VBA programming language,Visual Basic programming language
- Category