How to connect with internet explorer

[Harpreet Singh]

Hi Ninjas,

I am creating a project in which I have to Pick URL & Cell.value go to internet explorer.
From there i have to Choose that particular item and goto its Url. then copy the items url to Excel Page..

Hope you understand the situation.
Is That possible..,, Please Help me out...

 

[Marc L]

Hi !

Like here is the Excel formulas forum, it's not possible …

See samples in VBA forum threads and
do a googling on How to pilot Internet Explorer in VBA …
​

 

[ThrottleWorks]

Hi @Harpreet Singh , I guess it is possible. I have done kind of similar work couple of years ago. Can't recall exactly how I did it.

Please check below mentioned links. Might be useful.
http://www.techrepublic.com/article/pull-data-into-microsoft-excel-with-web-queries/

http://www.mrexcel.com/forum/excel-...s-code-extract-html-table-data-worksheet.html

Is it possible for you to share the URL you are working it.