Hi, Check the link below for the VBA code. http://funwithexcel.blogspot.com/2009/05/how-to-open-url-list-from-excel-using.html Hope this helps.
On Wed, May 20, 2009 at 4:10 PM, Lexster <lexste...@gmail.com> wrote: > > 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 > > > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
