Excel friends,
I need to read and copy a bunch of web pages in EXCEL 2010, easy to do with data-from web. The challenge for me is that the webpages have this code in there:
href="Javascript:serpShowTelephone('12345678','012345678'); The phone is shown only when you click on it!
So, the phone number is somehow embedded, and it is not shown a whole phone number in the copy extracted from the webpage.
How can I modify the query data-from web to actually copy the complete phone number?
The web page is a kind of internal webpage with name, address and phone. I would like to copy them clean and easily, using EXCEL 2010 VBA, if you have any advice I would appreciate. Otherwise, I have to copy them I clean the page kind of manually.
Thanks in advance for your help.
I need to read and copy a bunch of web pages in EXCEL 2010, easy to do with data-from web. The challenge for me is that the webpages have this code in there:
href="Javascript:serpShowTelephone('12345678','012345678'); The phone is shown only when you click on it!
So, the phone number is somehow embedded, and it is not shown a whole phone number in the copy extracted from the webpage.
How can I modify the query data-from web to actually copy the complete phone number?
The web page is a kind of internal webpage with name, address and phone. I would like to copy them clean and easily, using EXCEL 2010 VBA, if you have any advice I would appreciate. Otherwise, I have to copy them I clean the page kind of manually.
Thanks in advance for your help.
