Consulting

Results 1 to 3 of 3

Thread: open url page in vba?

  1. #1

    open url page in vba?

    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

  2. #2
    ActiveWorkbook.FollowHyperlink Address:="link here", NewWindow:=True

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •