from:"Don Flak"

Re: $$Excel-Macros$$ Using a macro to login to a web-site

2011-06-14 Thread Don Flak

Thanks so much.  I'll give both of those a try.

On Tue, Jun 14, 2011 at 8:07 PM, ashish koul  wrote:

>
> http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
>
> http://www.xlmacros.com/content/how-login-website-using-vba
>
> On Tue, Jun 14, 2011 at 8:41 PM, Don  wrote:
>
>> Hi,
>>
>> I know this can be done because I've seen it before.  I have to login
>> to a web-site and query some data.  I have the code to get me to the
>> web page but I have to login.  I know there is a way to write into the
>> macro to fill in the needed info and login.
>>
>> Any assitance is greatly appreciated.  What I believe to be the
>> relevant source code for the login page is shown below.
>>
>>
>> 
>>> href="#login">eFlash> a>
>>
>>Type your ACE login ID and password that you use to log into
>> your
>> ACE workstation.
>> 
>>  ACE Login ID:
>>
>> 
>> 
>>ACE Password:
>>> type="password"/>
>> 
>> Note: Password is case-sensitive
>> 
>>> >
>> 
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

2011-06-13 Thread Don Flak

H,

I tried the code and got a VB run-time error.

Run-time error '424';

Object required

There error highlights the yellow line below.

Here is the code as I have it installed.

' TEST Macro
' Macro recorded 6/10/2011 by Don Flak
'
'
Dim ie As Object
Set ie = CreateObject("Internetexplorer.Application")
ie.Visible = True
ie.Navigate "
https://crpl.usps.gov/uspsedw/servlet/mstrWeb?evt=5005&src=mstrWeb.report.5005&mstrWeb=-EAGNMNTWEB12.Accounting.34952_&report=*-1.*-1.0.0.0&sortBean=*-1.*-1.0.0..0&frame=*-1.*-1.0.0.*0.0.*-1.*0.*0&deFormatEditor=*-1.*-1.1.1.0..1..0..&rb=0.0.8704360C11E08B8DA22600804F472779.OT.*-1.16779648.1.0.0.0.0.1.0*.0*.100*.20*.100*.20*.0.1-2574165611E095C899A300804F87A575.0.1.1.0.6.1234833824.0.100.2000.0.0.0..1.100.1.20.*0.1_*0.*-1.*-1.0.*0.1.0.*0.2.1.1&dm=*-1.*-1.0.0.&deSaveAs=*-1.*-1.1.1.0.*0.0.0.*0.*0.*0.*0&deSaveAsFb=0.D43364C684E34A5F9B2F9AD7108F7828.*0.8.0.0-12288.2048_268453447.*-1.1.*0&reportGraph=*-1.*-1.0.0.&reportFT=*-1.*-1.0.0&GridAutoStyle=*-1.*-1.0.0..SelectedAutostyleID&vfep=*-1.*-1.0.0..0.0&deImport=*-1.*-1.1.1.0.1.1.30.2048%2C12288&5005=1
"
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 12
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
For Each oHTML_Element In HTMLDoc.getElementsByTagName("Export")

If oHTML_Element.Type = "submit" Then
oHTML_Element.Click
Exit For
End If
Next
Set ie = CreateObject("Internetexplorer.Application")
ie.Visible = True
ie.Navigate "
https://crpl.usps.gov/uspsedw/servlet/mstrWeb?evt=5005&src=mstrWeb.report.5005&mstrWeb=-EAGNMNTWEB12.Accounting.34952_&report=*-1.*-1.0.0.0&sortBean=*-1.*-1.0.0..0&frame=*-1.*-1.0.0.*0.0.*-1.*0.*0&deFormatEditor=*-1.*-1.1.1.0..1..0..&rb=0.0.6DB80E8411E08B8EA22600804F370779.FLEX.*-1.16779648.1.0.0.0.0.1.0*.0*.100*.20*.100*.20*.0.1-62F2C30611E095C899A300804F17C778.0.1.1.0.6.1234833824.0.100.2000.0.0.0..1.100.1.20.*0.1_*0.*-1.*-1.0.*0.1.0.*0.2.1.1&dm=*-1.*-1.0.0.&deSaveAs=*-1.*-1.1.1.0.*0.0.0.*0.*0.*0.*0&deSaveAsFb=0.D43364C684E34A5F9B2F9AD7108F7828.*0.8.0.0-12288.2048_268453447.*-1.1.*0&reportGraph=*-1.*-1.0.0.&reportFT=*-1.*-1.0.0&GridAutoStyle=*-1.*-1.0.0..SelectedAutostyleID&vfep=*-1.*-1.0.0..0.0&deImport=*-1.*-1.1.1.0.1.1.30.2048%2C12288&5005=1
"
Set ie = CreateObject("Internetexplorer.Application")
ie.Visible = True
ie.Navigate "
https://crpl.usps.gov/uspsedw/servlet/mstrWeb?evt=5005&src=mstrWeb.report.5005&mstrWeb=-EAGNMNTWEB12.Accounting.34952_&report=*-1.*-1.0.0.0&sortBean=*-1.*-1.0.0..0&frame=*-1.*-1.0.0.*0.0.*-1.*0.*0&deFormatEditor=*-1.*-1.1.1.0..1..0..&rb=0.0.597B42BE11E08B8FA22600804FA7E575.SDO.*-1.16779648.1.0.0.0.0.1.0*.0*.100*.20*.100*.20*.0.1-F0D9FC5C11E095C899A300804FB7077A.0.1.1.0.6.1234833824.0.100.2000.0.0.0..1.100.1.20.*0.1_*0.*-1.*-1.0.*0.1.0.*0.2.1.1&dm=*-1.*-1.0.0.&deSaveAs=*-1.*-1.1.1.0.*0.0.0.*0.*0.*0.*0&deSaveAsFb=0.D43364C684E34A5F9B2F9AD7108F7828.*0.8.0.0-12288.2048_268453447.*-1.1.*0&reportGraph=*-1.*-1.0.0.&reportFT=*-1.*-1.0.0&GridAutoStyle=*-1.*-1.0.0..SelectedAutostyleID&vfep=*-1.*-1.0.0..0.0&deImport=*-1.*-1.1.1.0.1.1.30.2048%2C12288&5005=1
"
End Sub



On Mon, Jun 13, 2011 at 2:08 AM, Rajan_Verma wrote:

>  \Hope it will help you
>
>
>
> For Each oHTML_Element In
> HTMLDoc.getElementsByTagName("Export")
>
>
>
>     If
> oHTML_Element.Type = "submit" Then
>
>
> oHTML_Element.Click
>
>
> Exit For
>
> End If
>
>Next
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Don Flak
> *Sent:* Saturday, June 11, 2011 5:36 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page
> Options
>
>
>
> No, but the site does acquire my login credentials through the workstation.
>  We utilize a single sign on, so when I log on to my work station, it
> maintains my credentials and permits access to several internal servers.  As
> I said, I don't have a problem with the code I wrote that gets me to the
> page and the report I need, I simply can't get over the last hurdle and
> "click" the export button.
>
>
>
> Thanks,
>
> Don
>
> On Sat, Jun 11, 2011 at 12:53 AM, Rajan_Verma 
> wrote:
>
> Is it HTTPS:// site?
>
> -Original Message-
>

Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

2011-06-11 Thread Don Flak

No, but the site does acquire my login credentials through the workstation.
 We utilize a single sign on, so when I log on to my work station, it
maintains my credentials and permits access to several internal servers.  As
I said, I don't have a problem with the code I wrote that gets me to the
page and the report I need, I simply can't get over the last hurdle and
"click" the export button.

Thanks,
Don

On Sat, Jun 11, 2011 at 12:53 AM, Rajan_Verma wrote:

> Is it HTTPS:// site?
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Don
> Sent: Saturday, June 11, 2011 12:18 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options
>
> I have to log onto our corporate reporting portal, click through
> several folders, execute data queries, export the data to a .csv file
> and then run some reports from that data.
>
> I have the code written to get to the the web-apge I need, and
> prepare
> the report for exporting.
>
>
> There is a button at the bottom of the page that simply is titled
> Export but it is a java enabled button.
>
>
> I need the code that would in essence, click the button and start the
> export.
>
>
> Any suggestions would be greatly appreciated.
>
>
> I can't post a link to the site because it is an internal, secured
> site.
>
>
> Thanks
>
>
>
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Using a macro to login to a web-site

Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

3 matches

Site Navigation

Mail list logo

Footer information