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!