+ Reply to Thread
Results 1 to 4 of 4

Clicking a submit button after macro opens webpage.

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Clicking a submit button after macro opens webpage.

    Afternoon All,
    I have spent hours trying different ways to get this to work and I just can't figure it out.

    I currently have a macro that opens up Internet Explorer to a webpage that I need info from. I then need it to click the submit button at the bottom to run the report. This is an internal website that houses volume data. I can not link straight to the webpage I need. When I try it says for security reasons you can not go straight to the pages you need to access through the website. So i have gotten it to open up the webpage I need all I need now is for the submit button to be pressed to load the report.

    Here is my current code:

    Please Login or Register  to view this content.
    Here is the HTML Code for the button on the website:


    Please Login or Register  to view this content.
    Last edited by CJPHX; 07-09-2010 at 09:48 AM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Clicking a submit button after macro opens webpage.

    Hello ,

    Here is the code...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: Clicking a submit button after macro opens webpage.

    thank you that worked great. My next question would be now how would I select the entire page and then copy and paste it into my excel document? Here is the code in whole so far.

    Please Login or Register  to view this content.
    End Sub

  4. #4
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: Clicking a submit button after macro opens webpage.

    I am getting a runtime error 91: Object Variable or With Block Variable not set. But the error only shows up sometimes. If I step through it works fine. If I just run it sometimes it works and sometimes it doesnt.

    Please Login or Register  to view this content.
    Last edited by CJPHX; 07-09-2010 at 08:59 AM.

+ 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