![]() ![]() ![]() 'loads a web page and returns True or False depending onįunction LoadWebPage(i_IE As SHDocVw.InternetExplorer, _ĭo While. ![]() Set GetNewIE = New SHDocVw.InternetExplorer 'returns new instance of Internet Explorerįunction GetNewIE() As SHDocVw.InternetExplorer The following function achieves exactly this by creating a new instance of the Internet Explorer and returning a pointer to it. But then you'll miss out on a lot of goodies like intellisense, full access to the object model via the object browser, access to the application's built-in constants, and a popup listing all the supported constants upon typing.īefore you can do anything with the Internet Explorer, of course you'll need one, and you'll need something to address it. If you can't find it in the list of available references, search for a file named shdocvw.dll, usually to be found in your Windows directory, subfolder System32.Īlternatively, you can skip the referencing and use late binding, defining the pointer to the Internet Explorer instance as Object instead of SHDocVw.InternetExplorer in your VBA code. and select the entry "Microsoft Internet Controls". Go to your Visual Basic Editor, Menu Tools -> References. To make the following code work, you'll need to include the "Microsoft Internet Controls" library in your VBA references first. But sometimes it's necessary to access them from your Excel Application (or Word or any other MS Office Application). Ok, Excel probably isn't the first thing that comes to mind when needing to deal with web pages. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |