+ Reply to Thread
Results 1 to 3 of 3

Coding Help for an excel document

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2010
    Posts
    2

    Coding Help for an excel document

    First I wanted to say thank you for helping if you can I really apreciate it!

    I was wondering if anyone can help me with some coding and information so I can get this excel sheet to do what I would like it to do. Some of the information is confidential and I may not be able to give some specific details but I will be as descriptive as possible. This is what I would like the sheet to do.

    With the click of a command button
    Go to certain URL
    Fill in the username and password field
    Then select a button "Login"
    After loading select a button (possible text button) Labeled "Interactions"
    After loading fill in a field below a label of "updated on"
    There are 2 fields that must be filled out which is beginning date and ending date (YYYY-MM-DD) I would prefer if this data could be pulled from the spread sheet A1 being beginning date A2 being ending date. NOTE: there is also a calender link that if clicked you can then select the date you wish and it will fill out the field for you.
    In addition to this I need it to fill out a form right after the words "showing" to the number 4000
    Afterward it needs to select a refresh button labeled "execute filters"
    When the page loads I want it to select all of the data on this page and paste it into colums C:L as values only.

    I hope this is enough information and that you can help! Also if you can label comments so I can make changes to this any help whatsoever is welcome I have never done any type of programming but can pick it up fast with some good comments.

    Thank you so much for your time!

  2. #2
    Registered User
    Join Date
    03-02-2012
    Location
    Phoenix
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Coding Help for an excel document

    Can anyone help me or at least put me on the right track?!

    Please Joshua

  3. #3
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Coding Help for an excel document

    Without knowing the URL it's difficult to give you specific help. For general help, search for "IE automation login".

    If you tell us the URL and it is publicly accessible, we can at least help you up to the login part of your request. After that stage, specific knowledge of the resulting web page is required, for example the HTML source.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1