Solved: Execute Commands in IE From Access
Hi, all,
I'm using the following chunk of code to output an Access query into HTML, then open the HTML file in Internet Explorer. The next step I would LIKE to accomplish is to select and copy the table from the Explorer window. I keep thinking that this should be simple enough, since Select All and Copy are just Edit menu commands, but I have not yet determined how to execute these commands in the Explorer window from my Access VBA. Any thoughts? Thanks in advance!! :hi:
[VBA]
Private Sub Command110_Click()
Dim strPath As String, strOCR As String
Dim objIE As InternetExplorer
strPath = FixPath(CurrentProject.Path)
strOCR = strPath & "temp_ocr.html"
DoCmd.OutputTo acQuery, "QyOCR_Table_HTML", "HTML(*.html)", strOCR, False, ""
Set objIE = New InternetExplorer
With objIE
.Navigate strOCR
.Visible = True
End With
End Sub
[/VBA]