I'm trying to use VBA to collect data directly from the internet. I have seen several examples of using the InternetExplorer Object, as below:
Dim IE as Object
Set IE = New InternetExplorer
IE.navigate "http://www.minhapagina.com.br"
html = IE.Document
So I could manipulate the 'html' Object and get the data I need, however, the 'Document' object is always empty. How to proceed?