Run the macro AutomateIE by going to Tools-Macro-Macros and double-click AutomateIE.

This sets the references to the VBscript Regular Expressions 5.5 and Internet Controls libraries disable this processing instruction so the document opens in Internet Explorer by default.

Run the macro SetRefs by going to Tools-Macro-Macros and double-click SetRefs. Just as in VBA, where the single quote signifies a comment.

Close the VBE, and save the file if desired.

Paste the code into the code window at right.

Hit Alt+F11 to open the Visual Basic Editor (VBE).

'If a match to our RegExp searchstring is found then launch this page 'String to parse google search for a VBAX reference Is there a macro code I can use that will apply to all links in that column. Excel can be used to automate internet explorer, loop through multiple pages for specific strings and then dump data.ĭim RegEx As RegExp, RegMatch As MatchCollectionĭo Until ie.ReadyState = READYSTATE_COMPLETE How to force Excel to open hyperlinks in IE (non-default browser) I have a column of links that were concatenated (site url+specific ID number) and I would like to open them in IE because that is the only place the links open in (the site is a company tool). You want to download data from an internet database. If a valid website is found via a regular expressions parsing search, then this web page is opened.įor more info on regular expressions please see This code runs a google search for 'vbax kb'. Automate Internet Explorer from Excel (google search)

Launch internet explorer vba excel