From Google Chrome putting URL, text in an Excel file (VBA or not ?)

[CD31]

Hi members !

By selecting a text in a web page (Excel) under Chrome browser, I want to :

- input some keywords of my own and

- add to an existing Excel file (the URL, the keywords and the text).

Can EXCEL VBA do such automatized process without opening EXCEL ?
Other tools necessary ?


Many thanks for your hints.

 

[Marc L]

Hi,

must be logic ‼ VBA is an Excel inner tool, so if Excel closed, no VBA !

Must ask to Google if its Firefox webbrowser clone could be automatized …
Firefox maybe soon …

As Excel is a Microsoft product, you can pilot Microsoft Internet Explorer
via VBA, many tutorials and samples on the web …
​

 

[CD31]

Thanks Marc
I only said with Excel in the background, of course (to use EXCEL vba ressources) ! I would avoid activating Excel, running the macro... Best would be automating direct from Chrome. But I have found a web automation tools, Selenium has seemingly functionalities to cooperate with Excel and Chrome https://code.google.com/p/selenium-vba/
I feared that such tools would be too complex to implement (requires installation of new softare which is no possibl...).
So I was looking for a EXCEL VBA solution which is available.
Google Chome gives me satisfaction but there may be less piloting availabilities than Explorer, indeed.
Nice evening.