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 |
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