Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-06 Thread OpenExcel.com
Hope this helps --> http://www.excelitems.com/2009/03/access-search-engines-on-browser.html. Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com __

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-06 Thread Ken Roedel
Alternatively, you can reference the Microsoft Internet Controls library from the VBA IDE and use the methods and props of ShDocVw.InternetExplorer application object to navigate around. -Ken On Mon, Dec 6, 2010 at 1:01 AM, kanwaljit Singh wrote: > Thanks, > > I am trying to fill info into a we

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-05 Thread kanwaljit Singh
Thanks, I am trying to fill info into a web form in IE On Mon, Dec 6, 2010 at 9:49 AM, Ken Roedel wrote: > This is most important question to ask: What are you trying to do with IE > from Excel? > > -Ken > > > On Sun, Dec 5, 2010 at 3:28 PM, kanwal_no1 wrote: > >> Hi All, >> >> I am using the

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-05 Thread Ken Roedel
This is most important question to ask: What are you trying to do with IE from Excel? -Ken On Sun, Dec 5, 2010 at 3:28 PM, kanwal_no1 wrote: > Hi All, > > I am using the following portion of a code to open the Internet > Explorer from Excel > > Sub OpenIE() > Dim IE As Object > Dim frmT As Obj

$$Excel-Macros$$ Open Internet Explorer automatically from Excel

2010-12-05 Thread kanwal_no1
Hi All, I am using the following portion of a code to open the Internet Explorer from Excel Sub OpenIE() Dim IE As Object Dim frmT As Object Dim doc As Object Dim opt As Object Dim ws1 As Worksheet Dim drop As Integer Set ws1 = Worksheets("Check") Set IE = CreateObject("InternetExplorer.