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
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
ActiveWorkbook.FollowHyperlink Address:="link here", NewWindow:=True
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.