How can we use MSHTML with VBA?

excel vba mshtml
Martin08 picture Martin08 · Mar 6, 2009 · Viewed 24.9k times · Source

I saw a lot of examples in MSDN on how to use MSHTML in VS. Have anyone known if and how we can use MSHTML and VBA to open web pages?

Answer

Will Rickards picture Will Rickards · Mar 6, 2009

In the VBA editor, you go under Tools -> References and add a reference to the Microsoft HTML Object Library [MSHTML.TLB]. Here is a link with an example in VBA.

Related questions

Submit form and fetch data from website VBA

I'm trying to fetch data from this site using VBA in Excel. What I tried to do and what worked was using InternetExplorer object like this: Set IE = CreateObject("InternetExplorer.Application") IE.Visible = False IE.Navigate "http://zertifikate.finanztreff.de" …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More