Just something I wanted to share because I was excited about it! Using the code: ActiveWorkbook.FollowHyperlink Address:="http:// www.cnn.com"
One can avoid importing object libraries and using shells and such to open external programs through Excel (Or any Office program using VBA, I would assume), by opening up internet explorer instead and pointing the URL to the path of the file you want to open. I did this with a publisher file because I could not figure out how to open up the publisher file from Excel. If anyone has any light to shed on that it would be appreciated, for future reference. Granted, using the IE workaround, one cannot control the file / application being opened (I believe?), but its a fine workaround if all you need to do is open it. Dustin --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
