| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA Script to Open URLs from a list in Excel
Hi.
I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1", first cell reference ="B2". I have about 20 links and I am constantly adding to the list. Could someone please help me with a VBA script that will automatically go down the list and open up each url link? It would stop running the script after it hits a blank cell. I also would like to use the same browser window, if not then could it be possible to include a command to close the web browser after each click? Any help, suggestions, tips would be most appreciated. Thank you in advance. Lex |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need VBA Script to Open URLs from a list in Excel
Sub FollowHyperlinks()
Dim R As Integer For R = 1 To ActiveSheet.UsedRange.Rows.Count ActiveWorkbook.FollowHyperlink Address:=Cells(R, 1) Next R Cells(1, 1).Activate End Sub "Lexster" wrote in message ... Hi. I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1", first cell reference ="B2". I have about 20 links and I am constantly adding to the list. Could someone please help me with a VBA script that will automatically go down the list and open up each url link? It would stop running the script after it hits a blank cell. I also would like to use the same browser window, if not then could it be possible to include a command to close the web browser after each click? Any help, suggestions, tips would be most appreciated. Thank you in advance. Lex |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need VBA Script to Open URLs from a list in Excel
Thank you so much for your help! It worked.
On May 20, 9:51*pm, "Maxx" wrote: Sub FollowHyperlinks() Dim R As Integer For R = 1 To ActiveSheet.UsedRange.Rows.Count ActiveWorkbook.FollowHyperlink Address:=Cells(R, 1) Next R Cells(1, 1).Activate End Sub "Lexster" wrote in message ... Hi. I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1", first cell reference ="B2". I have about 20 links and I am constantly adding to the list. *Could someone please help me with a VBA script that will automatically go down the list and open up each url link? *It would stop running the script after it hits a blank cell. *I also would like to use the same browser window, if not then could it be possible to include a command to close the web browser after each click? Any help, suggestions, tips would be most appreciated. Thank you in advance. Lex- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 + script to open and automatically close an excel workb | Excel Discussion (Misc queries) | |||
| Convert list of URLs to Hyperlinks | Excel Discussion (Misc queries) | |||
| Excel wants to save an open file to another filename in VBA script | Excel Programming | |||
| How Do I Use List Box for VBA Script that Converts Excel Files to Any FIle Type? | Excel Programming | |||
| I`m want excel to automaticly put urls at a url. | Excel Discussion (Misc queries) | |||
Linear Mode
