Automate excel to copy text generated from a webpage back to excel
$10-30 USD
Ukończony
Opublikowano ponad 10 lat temu
$10-30 USD
Płatne przy odbiorze
Hi
We have 25000 listings on eBay and most of them are listed on non English speaking sites
We want to add a listing translator provided by a third party. This consists of some HTML code that is added to the top of the description.
To do this 25000 times would be very time consuming, it would be better to use excel to copy and paste and repeat.
Here is how it should work
Start with the list of listing numbers and item descriptions (html) for each site
When we run the script, excel should take each listing number and paste it into the field on the website (see attached screen shot of the website). Then click generate code.
Then excel should copy the code from the website to excel and paste it into the cell that contains the item description
Then repeat
Thanks
Hi,
I've worked with data retrieving from websites with excel before. I can submit each listing number to your listing translator, and store the code generated in the excel file.
I'll need the translator's url and the excel file with the listing numbers. And I'll deliver the excel file with the data generated from the translator and macro required to do the job in future.
Please let me know any comment/doubt.
Regards,
David.