om
Subject: RE: $$Excel-Macros$$ Excel Macro to navigate IE
Hi Kiran,
No problem. I wanted to investigate if their was any way to get web
queries to work with your URLs. Notice that the links I gave describe how
to work with parameters in some cases. Also you might be able to use Yahoo!
Pipes or
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.
ooglegroups.com]
> On Behalf Of Kiran Kancherla
> Sent: Wednesday, February 01, 2012 8:58 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Excel Macro to navigate IE
>
> ** **
>
> ** **
>
> Hi All,
>
> ** **
>
>
@googlegroups.com]
On Behalf Of Kiran Kancherla
Sent: Wednesday, February 01, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Macro to navigate IE
Hi All,
If any of have Macro ''click'' or ''navigate'' internet explorer...
My r
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
Hi All,
If any of have Macro ''click'' or ''navigate'' internet explorer...
My requirement is to click 3 hyper links and copy the data to Excel
I have tried googling it..
But no luck..
Sent on my BlackBerry® from Vodafone
Thanks & Regards.
Kiran
--
FORUM RULES (986+ members already BANNE
