I'm trying to experiment with interconectivity with VBA and Excel, so I can do things like past info from an excel spreaf into a web form. I've written the code below but it's not working!
Sub test()
Dim IE As InternetExplorer
Set IE = New SHDocVw.InternetExplorer
IE.Visible = True
IE.Navigate2 ("http://www.google.com")
test1 = IE.document.fileSize
MsgBox (test1)
End Sub
I'm having problems with the SHDocVw.InternetExplorer.Document line (written IE.Document)
I've added the following references to the code,
Microsoft HTML object library
Microsoft Internet Controls
I think I may need to add more libraries but I don't know which ones! This may not be the only problem though!
Bookmarks