arting off
point)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 9:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE
Hi Asa,
I am sorry. I can n
ps.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 9:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE
Hi Asa,
I am sorry. I can not give you the URL as it has some confidential
informa
2 21:27:42
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Excel Macro to navigate IE
Kiran,
Can you give an example of a web page and the links the macro would click on
it?
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On B
: $$Excel-Macros$$ Excel Macro to navigate IE
Hi Asa,
I agree with you. Excel can extract Web query.
In my current requirement i don't have a constant URL to download the data.
Like www.Google.com -> Calender -> (My case URL is only one)
These kind of URLS I have.
Hi Asa,
I agree with you. Excel can extract Web query.
In my current requirement i don't have a constant URL to download the data.
Like www.Google.com -> Calender -> (My case URL is only one)
These kind of URLS I have.
The Macro need to open IE click on Specified links and copy the data to
Ex
Hello Kiran,
Have you considered the approach of using web queries? Excel can
automatically retrieve data from URLs that contain tables or XML/RSS and put
it in a worksheet. Excel can also automatically refresh the data from the
web on a set schedule if desired. The feature works in all version
cros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE
You can start with this
Public Sub directa()
Const strURL_c As String = "http://www.xyz.com";
Const strUsr_c As String = "ABC"
Const strPwd_c As String = "DEF"
Dim objIE As SHDocVw
You can start with this
Public Sub directa()
Const strURL_c As String = "http://www.xyz.com";
Const strUsr_c As String = "ABC"
Const strPwd_c As String = "DEF"
Dim objIE As SHDocVw.InternetExplorer
Dim ieDoc As MSHTML.HTMLDocument
Dim tbxPwdFld As MSHTML.HTMLInputElement
