I had an excel macro used to open an internet explorer application and manipulate the program. It worked perfectly for quite some time. However, some of my users have discovered that they need 64 bit internet explorer running in order to maintain some of their printing preferences (the macro automatically prints pages from our website). The macro could work if the internet explorer program was launched from the link C:\Program Files\Internet Explorer\IExplore.exe.
My previous code to open the ie program was:
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.navigate ("URL")
How can I make it so that my object ie specifically opens the internet explorer through the file path C:\Program Files\Internet Explorer\IExplore.exe and creates it as the object just as it did previously? The internet explorer installed on our computers is ie9 if that matters.