ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to write a VBA program to load the webpages automatically (https://www.excelbanter.com/excel-programming/446065-how-write-vba-program-load-webpages-automatically.html)

cyberdude

How to write a VBA program to load the webpages automatically
 
Hi,

I have an excel spreadsheet containing hundreds of web links. For
example,

In cell A1, it is http://abc.com
In cell A2, it is http://bbc.com
....

I need to copy each link to a web browser and open the page to check
the font on it.

I don't want to do the copying and pasting hundreds of times, what VBA
codes would

help me do the job? Thank you.

Mike


GS[_2_]

How to write a VBA program to load the webpages automatically
 
cyberdude laid this down on his screen :
Hi,

I have an excel spreadsheet containing hundreds of web links. For
example,

In cell A1, it is http://abc.com
In cell A2, it is http://bbc.com
...

I need to copy each link to a web browser and open the page to check
the font on it.

I don't want to do the copying and pasting hundreds of times, what VBA
codes would

help me do the job? Thank you.

Mike


Just click the link and (if it's valid) your browser will open to the
page.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com