Can we paste values in search fields and copy the search result from public WEB?

[riya]

Hi All,
I have a general question,
For example in Excel file i have 2 coulumns where are multiples records and based on both column i have to search the values on a public website.
While enter the values on web i get Output when i click on Search button.

Shall i copy that output from web and paste in Excel file from VBA ?


Column 1 Column 2 Output(Order Count)
Laptop Mobile 87
Remote Car 69
Mobile Charger 70

etc....

 

[Marc L]

Hi !

As it depends on the worksheet data structure and the website
so no generic code is possible, the answer is maybe yes, maybe no …

See also the inner Excel worsheet Web functions and PowerQuery.
​

 

[riya]

Hi , Worksheet Data is in structured way, There are only 2 columns and i have to enter 1st column value on website search field and 2 column value on website search field, and when we press enter Result have to copy & paste in Worksheet 3rd column.
Your suggestions is highly appreciated.

 

[Marc L]

​

 

[riya]

No luck.. Finding the solution from 1 week but could not get result

 

[Marc L]

As we can't guess, see the many samples in threads of this forum
but all specific to a particular website …

A must read (among others) : Web Scraping archives …

If you can’t explain it simply, you don’t understand it well enough … (Albert Einstein)
​