vba完全關閉IE瀏覽器及調用IE瀏覽器的簡單應用
- 2021-04-25 08:00:00
- tmtony8 翻譯
- 19820
在調用IE對象時,多次調用會出現錯誤,防止多次調用IE對象,可以把把IE瀏覽器對象徹底地關閉
添加一個IE_Sledgehammer函數確保IE瀏覽器完全關閉
Sub IE_Sledgehammer() Dim objWMI As Object, objProcess As Object, objProcesses As Object Set objWMI = GetObject("winmgmts://.") Set objProcesses = objWMI.ExecQuery("SELECT * FROM Win32_Process WHERE Name = 'iexplore.exe'") For Each objProcess In objProcesses On Error Resume Next Call objProcess.Terminate Next Set objProcesses = Nothing: Set objWMI = Nothing End Sub
瀏覽器完全關閉后,調用IE瀏覽器
Call IE_Sledgehammer Set ie = CreateObject("InternetExplorer.Application")
1. VBA調用 InternetExplorer IE瀏覽器組件
Sub IE() ' Create Internet Explorer Application, going on the internet! Set IE = CreateObject("InternetExplorer.Application") ' Internet Explorer Visible IE.Visible = True ' Internet Explorer Left & Top Position on the screen IE.Left = 0 IE.Top = 0 ' Internet Explorer Height & Width Settings IE.Height = 1024 IE.Width = 1280 ' Internet Explorer Navigate To office-cn IE.Navigate "ctxi.cn" To stop IE I use a command button with as code under the click event : ' Stop & Close Internet Explorer IE.Stop IE.Quit End Sub
'This Must go at the top of your module. It's used to set IE as the active window Public Declare Function SetForegroundWindow Lib "user32" (ByVal HWND As Long) As Long Sub Automate_IE_Enter_Data() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As Object Dim objElement As Object Dim objCollection As Object Dim HWNDSrc As Long 'Create InternetExplorer Object Set IE = CreateObject("InternetExplorer.Application") 'Set IE.Visible = True to make IE visible, or False for IE to run in the background IE.Visible = True 'Define URL URL = "http://ctxi.cn" 'Navigate to URL IE.Navigate URL ' Statusbar let's user know website is loading Application.StatusBar = URL & " is loading. Please wait..." ' Wait while IE loading... 'IE ReadyState = 4 signifies the webpage has loaded (the first loop is set to avoid inadvertantly skipping over the second loop) Do While IE.ReadyState = 4: DoEvents: Loop Do Until IE.ReadyState = 4: DoEvents: Loop 'Webpage Loaded Application.StatusBar = URL & " Loaded" 'Get Window ID for IE so we can set it as activate window HWNDSrc = IE.HWND 'Set IE as Active Window SetForegroundWindow HWNDSrc 'Find & Fill Out Input Box n = 0 For Each itm In IE.document.all If itm = "[object HTMLInputElement]" Then n = n + 1 If n = 3 Then itm.Value = "orksheet" itm.Focus 'Activates the Input box (makes the cursor appear) Application.SendKeys "{w}", True 'Simulates a 'W' keystroke. True tells VBA to wait 'until keystroke has finished before proceeding, allowing 'javascript on page to run and filter the table GoTo endmacro End If End If Next 'Unload IE endmacro: Set IE = Nothing Set objElement = Nothing Set objCollection = Nothing End Sub
分享
Access數據庫自身
- office課程播放地址及課程明細
- Excel Word PPT Access VBA等Office技巧學習平臺
- 將( .accdb) 文件格式數據庫轉換為早期版本(.mdb)的文件格式
- 將早期的數據庫文件格式(.mdb)轉換為 (.accdb) 文件格式
- KB5002984:配置 Jet Red Database Engine 數據庫引擎和訪問連接引擎以阻止對遠程數據庫的訪問(remote table)
- Access 365 /Access 2019 數據庫中哪些函數功能和屬性被沙箱模式阻止(如未啟動宏時)
- Access Runtime(運行時)最全的下載(2007 2010 2013 2016 2019 Access 365)
Access Activex第三方控件
- Activex控件或Dll 在某些電腦無法正常注冊的解決辦法(regsvr32注冊時卡?。?/a>
- office使用部分控件時提示“您沒有使用該ActiveX控件許可的問題”的解決方法
- RTF文件(富文本格式)的一些解析
- Access樹控件(treeview) 64位Office下出現橫向滾動條不會自動定位的解決辦法
- Access中國樹控件 在win10電腦 節(jié)點行間距太小的解決辦法
- EXCEL 2019 64位版(Office 2019 64位)早就支持64位Treeview 樹控件 ListView列表等64位MSCOMMCTL.OCX控件下載
- VBA或VB6調用WebService(直接Post方式)并解析返回的XML
Access ADP Sql Server等
- 早期PB程序連接Sqlserver出現錯誤
- MMC 不能打開文件C:/Program Files/Microsoft SQL Server/80/Tools/Binn/SQL Server Enterprise Manager.MSC 可能是由于文件不存在,不是一個MMC控制臺,或者用后來的MMC版
- sql server連接不了的解決辦法
- localhost與127.0.0.1區(qū)別
- Roych的淺談數據庫開發(fā)系列(Sql Server)
- sqlserver 自動備份對備份目錄沒有存取權限的解決辦法
- 安裝Sql server 2005 express 和SQLServer2005 Express版企業(yè)管理器 SQLServer2005_SSMSEE
文章分類
聯系我們
聯系人: | 王先生 |
---|---|
Email: | 18449932@qq.com |
QQ: | 18449932 |
微博: | officecn01 |