shell函数
shell "iexplore_path yourURL"
shell "iexplore_path yourURL"
解决方案 »
- 请教一个SQL语句
- [请教贴]VB是单工程好,还是多工程好
- 做一个小型实用的应用程序,可能会用到数据库,一般需要多少开发费用
- winsock连续getdata的问题
- <VB.NET 项目开发实践> 自学习光盘内容免费下载!
- 在vb中如何从一条字符串中截取我要的字符串?青高手指教
- 有合肥市的吗?我初学VB香请教写问题,可以更方便我找的,不怕麻烦的,如果可能可以做个朋友
- ★★★快来抢100分★★★:可不可以控制mschart控件中x轴每个刻度的宽度,以及让图表上下,左右滚动?
- 有没有高手???
- VB的图像翻转和缩放能否同时处理??和保存??请求帮助(LIKEVB) 送分的,真的
- 请问怎么清空回收站?能不能调用什么函数啊?
- 如何用vb实现stack,quence,link等数据结构?
Sub AutomateIE() Dim ie As Object
Dim result As Integer
Dim myRow As Integer, myCol As Integer
Dim myURL As String
'
' Get activecell value, must be a valid
' web address
'
myRow = ActiveCell.Row
myCol = ActiveCell.Column
myURL = ActiveSheet.Cells(myRow, myCol)
'
' Set up the Automation object
'
Set ie = CreateObject("InternetExplorer.Application")
'
' Navigate to a page and customize the browser window
'
ie.Navigate "http://" & myURL
ie.Toolbar = False ' }set these to true if you want to have the
ie.StatusBar = False ' }toolbar, statusbar and menu visible
ie.MenuBar = False ' }
'
' keep itself busy while the page loads
'
Do While ie.Busy
DoEvents
Loop
'
' Display page info
'
result = MsgBox( _
"Current URL: " & ie.LocationURL & vbCrLf & _
"Current Title: " & ie.LocationName & vbCrLf & _
"Document type: " & ie.Type & vbCrLf & vbCrLf & _
"Would you like to view this document?", _
vbYesNo + vbQuestion) If result = vbYes Then
'
' If Yes, make browser visible
'
ie.Visible = True
Else
'
' If no, quit
'
ie.Quit
End If Set ie = Nothing End Sub