Hey,
I found code already to do this and it works wonderfully on my own computer. But when other people use the macro, it gives the "Type Mismatch" error. I verify that the correct references are selected (Microsoft Internet Controls and Microsoft HTML Object Library), but it still gives the error. I've posted the code below. Would someone be able to help?
Dim shellWins As ShellWindows
Dim IE As InternetExplorer
Dim IEinput As HTMLDocument
Set shellWins = New ShellWindows
If shellWins.Count > 0 Then
' Get IE
Set IE = shellWins.Item(0)
Else
' Create IE
Set IE = New InternetExplorer
IE.Visible = True
End If
Set IEinput = IE.document '<--This is where I get the error
Thank you in advance!!
Bookmarks