I need a web scraper to be created with excel VBA, I've completed the first part of the code to access the website and the login, what I need the code to do now is:
1-select one of the options in the drop down menu.
2-pass a value in a text field from the same workbook in sheet "RawData", and click on "Find"
3- from the page will be directed to after clicking on Find, I want one of the fields in the table to be copied to the same workbook.
and loop through this for a number of values in the rawdata.
I wont be able to provide you with the link as its an intranet, however I can provide you with screenshots from the inspect on the browser
Sorry my budget is very limited for this (15$), and I really cant increase it
After chatting with you i have looked at what you need to be done. I can do it provided that it does not need to run in the background. It is also a challenge not being able to text what i am writing as i am going and will therefore require an amount of back and forth on certain things. I have written the first part of the code, where it should select from the drop down box, fill in from column a in to the search field and then click find.
I would now need to make the application wait while the results are gathered, then extract the required information from the page.
$14 USD om 1 dag
0,0 (1 omtale)
0,0
0,0
6 frilansere byr i gjennomsnitt $19 USD for denne jobben
I am an expert with Excel VBA.
I can help you with your task. I have succesfully worked on various VBA projects.
Please read my 300+ reviews. I am here to impress you with my work. ZERO ERROR GUARANTEED!!
I have more than 20 years of experience in VBA either Word, Excel or Powerpoint. I have made many running but complicated VBA code calculating for complicated formula and display them.
Hey there,
I have never tried scraping an intranet yet but I am up for the challenge. I have done some private webscraping in VBA and am familiar with it.
I will work with you until you are satisfied with the outcome.
Thank you