+ Reply to Thread
Results 1 to 6 of 6

Using internet explorer through VBA

  1. #1
    Registered User
    Join Date
    10-30-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    22

    Using internet explorer through VBA

    Hi,

    I havent posted here for a while but have stumbled to a another wall on my new project.

    JPG file attached of the website in question.

    What I am trying to do is fill the trip details on the trip line, tick add return trip box and press save trip. This would happen for every day of the month.

    I am not sure if this is possible and would appreciate all the help if it is. If this is doable I will be seeking some advise how to get to this page in the first place

    Thanks for looking.
    Attached Images Attached Images

  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,258

    Re: Using internet explorer through VBA

    Hello bodis,

    This task could be automated using VBA. Since you must be registered with the site, you are also required to log in before you get to the page you have posted. You didn't mention if you are required to log out each day.

    There are really three parts to this.
    1) Log in
    2) fill the trip form
    3) log out

    You don't mention which version of Internet Explorer you are using. I have programming experience only up to version 6.0. I am guessing from the jpg you are using IE 7.0 or higher. The macro coding is based on the information in the web pages. It would be necessary to see the page source code to create the macro. This is little difficult since site access is restricted to registered user.
    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
    Registered User
    Join Date
    10-30-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Using internet explorer through VBA

    Hi, thanks for your reply. The IE version I am not sure of the IE version we are using until tomorrow, picture attached is from my home laptop, we use windows XP and citrix at work so I believe IE6 is used. I can confirm tomorrow.

    actually looking at the website it is going to be 5 different steps to get to the fill information and about 2 more to finish the whole process. But it is not done daily, it would be done once a month when the macro is run to do this.

    I could post pictures of each step and get ie version in the morning if that helps.

    Thanks again for the help.

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

    Re: Using internet explorer through VBA

    Hello bodis,

    It would be more helpful if you save the source code from each page and post them. To retrieve the source code go to View > Source. This will create a text file displayed in Notepad. You can then save these files, zip them, and post the zipped folder.

  5. #5
    Registered User
    Join Date
    10-30-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Using internet explorer through VBA

    Dear Leith

    Could I send the source codes of the webpages direct to you as they contain quite a bit of private information, but I dont seem to see attach icon on private message.

    Regards

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

    Re: Using internet explorer through VBA

    Hello bodis,

    You can email them directly to me at [email protected].

+ 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