Web pages to excel - no shell neither send keys, synchronous steps
Budget: $30 – $250 USD
I offer 250 usd
Summary
1. Read urls from a file, one for one
2. Load the url in google
3. The content of the page will be past to Excel,
4. Each past of the text of the pages are pasted at the botton of the sheet
Get text of the webpage
5. Open excel
6. Open Google
7. Macro opens a text file
8.
9. Read a line of the file, each line is an url
10. Google go to a url of investing.com (read in text file)
11. Until the page has been completely loaded, selecta ll the content
12. Copy the clipboard the content of the page, it will be done when the page was loaded
13. Change to Excel
14. Past the the content of the page
15. Go to the end last row and move some 5 rows more, because next page also will be pasted
16.
17. Read a next line of the file, each line is an url
18. Return to Google and go to a url of investing.com
19. Until the page has been completely loaded, selecta ll the content
20. Copy the clipboard the content of the page, it will be done when the page was loaded
21. Change to Excel
22. Past the the content of the page
23. Go to the end last row and move some 5 rows more, because next page also will be pasted
24. Until all the file is read until the last line
25. At the end will contain the text of all urls that were loaded in chrome
The file text will contains the followings urls
https://www.investing.com/currencies/eur-usd-technical
https://www.investing.com/currencies/aud-jpy-technical
https://www.investing.com/currencies/gbp-cad-technical
Important Notes
26. Macro en VBA
27. Macro must have the control of Excel and Google
28. No selenium can be used
29. Use APIs of Windows and Kernel o whatever, but having the control for synchronus steps
30. All must be syncronous,
a. it means, wait pages are totally displayed before select the content
b. Past in Excel only if the content of the page is on the clipboard
31. Syncronus actions are required
I am programmer also, but i am really busy, i will be review the code, i thinks that with Windows and kernel api sould be controlled the Windows of the google, Excel
Summary
1. Read urls from a file, one for one
2. Load the url in google
3. The content of the page will be past to Excel,
4. Each past of the text of the pages are pasted at the botton of the sheet
Get text of the webpage
5. Open excel
6. Open Google
7. Macro opens a text file
8.
9. Read a line of the file, each line is an url
10. Google go to a url of investing.com (read in text file)
11. Until the page has been completely loaded, selecta ll the content
12. Copy the clipboard the content of the page, it will be done when the page was loaded
13. Change to Excel
14. Past the the content of the page
15. Go to the end last row and move some 5 rows more, because next page also will be pasted
16.
17. Read a next line of the file, each line is an url
18. Return to Google and go to a url of investing.com
19. Until the page has been completely loaded, selecta ll the content
20. Copy the clipboard the content of the page, it will be done when the page was loaded
21. Change to Excel
22. Past the the content of the page
23. Go to the end last row and move some 5 rows more, because next page also will be pasted
24. Until all the file is read until the last line
25. At the end will contain the text of all urls that were loaded in chrome
The file text will contains the followings urls
https://www.investing.com/currencies/eur-usd-technical
https://www.investing.com/currencies/aud-jpy-technical
https://www.investing.com/currencies/gbp-cad-technical
Important Notes
26. Macro en VBA
27. Macro must have the control of Excel and Google
28. No selenium can be used
29. Use APIs of Windows and Kernel o whatever, but having the control for synchronus steps
30. All must be syncronous,
a. it means, wait pages are totally displayed before select the content
b. Past in Excel only if the content of the page is on the clipboard
31. Syncronus actions are required
I am programmer also, but i am really busy, i will be review the code, i thinks that with Windows and kernel api sould be controlled the Windows of the google, Excel