PDA

View Full Version : open url page in vba?



mushynator
01-24-2008, 03:48 PM
Hi, does anyone know how to open a url in vba?
I have an internal intranet and I would like to open a page by using its link. Can vba do that? Would I be able to create a macro that opens the page?

Thanks

Opawesome
01-24-2008, 06:38 PM
ActiveWorkbook.FollowHyperlink Address:="link here", NewWindow:=True

mushynator
01-25-2008, 02:23 PM
That worked perfectly. Thanks a bunch. However, when the macro executes, before it loads the url page, it asks for a confirmation. it Says "Opening (this link). Some files can contain viruses or otherwise be harmful to your computer. ... Would you like to open this file?"
Is there a way to automatically have the excel macro say "Ok" to this box?

Thanks again.