使用VBA在Internet Explorer中打开链接 [英] Specifically Opening a Link in Internet Explorer using VBA

查看:212
本文介绍了使用VBA在Internet Explorer中打开链接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我使用下面的代码打开在工作表上编译的链接,但我需要这些链接在Internet Explorer中专门打开,即使它未设置为默认浏览器。如果有人有任何想法,将不胜感激。谢谢。

I am using the code below to open links that are compiled on a sheet, but I need these links to open specifically in internet explorer even when it is not set as the default browser. If anyone has any ideas it would be greatly appreciated. Thank you.

推荐答案

以下适用于我:

The following works for me:

Sub GetIE()
  Dim IE As Object
  Set IE = CreateObject("InternetExplorer.Application")
  IE.Visible = True
  IE.Navigate "http://www.projectplanning.co.nz/"
  Set IE = Nothing
End Sub


这篇关于使用VBA在Internet Explorer中打开链接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆