+ Reply to Thread
Results 1 to 11 of 11

VBA code in Excel doesn't recognize form from Internet Explorer

  1. #1
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    VBA code in Excel doesn't recognize form from Internet Explorer

    I'm trying to login into a page in Internet Explorer through a VBA code in Excel. The problem is my code doesn't recognize the Login and Password forms. Does anyone have any idea?

    This is the website: http://www.trademap.org/

    Here is my code:

    Please Login or Register  to view this content.
    Thanks.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    What do you mean by 'does not recognize'?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    It's in a frame, it's not actually in the page that you're navigating to

  4. #4
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by Norie View Post
    What do you mean by 'does not recognize'?
    It gives me the following error:

    Please Login or Register  to view this content.
    I tested the same code in similar pages, and the form is recognized there. But in this specific page it doesn't work.

  5. #5
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by Kyle123 View Post
    It's in a frame, it's not actually in the page that you're navigating to
    I've tried with the direct link, but It didn't work as well. http://www.trademap.org/popuplogin.aspx

    Any suggestion?

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    It's not in that page either. The somewhat mighty link is:
    http://mas-admintools.intracen.org/a...anonymous=true

  7. #7
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by Kyle123 View Post
    It's not in that page either. The somewhat mighty link is:
    http://mas-admintools.intracen.org/a...anonymous=true
    I'd success with the Code recognizing the forms through this link: http://mas-admintools.intracen.org/a...n))/Login.aspx

    But... it doesn't login. When I put my login and password there, it won't login into my account.
    Last edited by rodrigoo; 04-14-2016 at 09:38 AM.

  8. #8
    Registered User
    Join Date
    02-16-2017
    Location
    Istanbul
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Dear Rodrigoo,

    Exactly after one year, I wonder if you have found any solution(s) to this problem. I am working on the same page to automate the downloads and received the same error message.

    I will be glad if you reply.

    Quote Originally Posted by rodrigoo View Post
    I'd success with the Code recognizing the forms through this link: http://mas-admintools.intracen.org/a...n))/Login.aspx

    But... it doesn't login. When I put my login and password there, it won't login into my account.
    Last edited by Mekrog; 04-14-2017 at 07:47 AM.

  9. #9
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by Mekrog View Post
    Dear Rodrigoo,

    Exactly after one year, I wonder if you have found any solution(s) to this problem. I am working on the same page to automate the downloads and received the same error message.

    I will be glad if you reply.
    Hello Mekrog,

    unfortunately I couldn't find a solution for this specific problem.

    Nevertheless, I found another way to get the information I needed. The thing is TradeMap has a mobile website (m.trademap.org) that doesn't require login to access some data. For me it worked because all I wanted was the data regarding the HS 6 code.

    I hope this reply is useful to you.

  10. #10
    Registered User
    Join Date
    02-16-2017
    Location
    Istanbul
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by rodrigoo View Post
    Hello Mekrog,

    unfortunately I couldn't find a solution for this specific problem.

    Nevertheless, I found another way to get the information I needed. The thing is TradeMap has a mobile website (m.trademap.org) that doesn't require login to access some data. For me it worked because all I wanted was the data regarding the HS 6 code.

    I hope this reply is useful to you.
    Hi Rodrigoo,

    Thanks for the information. I checked the mobile website and I can use it but I suppose it is not as up-to-date as the actual website. If I solve the main problem, I will inform you from here.

  11. #11
    Registered User
    Join Date
    04-14-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    6

    Re: VBA code in Excel doesn't recognize form from Internet Explorer

    Quote Originally Posted by Mekrog View Post
    Hi Rodrigoo,

    Thanks for the information. I checked the mobile website and I can use it but I suppose it is not as up-to-date as the actual website. If I solve the main problem, I will inform you from here.
    Mekrog,

    The mobile site shows an incorrect indicator of year. I'm not sure if that's what you're talking about, but see this example:

    Normal website

    Mobile

    It's the same values, but in the mobile version it says is from 2015.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macros for copy paste excel data on to Internet explorer form
    By Zuber Ahmed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 08:09 AM
  2. [SOLVED] Internet explorer to be closed while executing the code... please advice
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2013, 05:50 AM
  3. VBA and Internet Explorer Code help needed
    By jtorrez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 03:42 PM
  4. VB CODES to open internet explorer & fill form automaticlly
    By sheikhmisbah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 03:55 PM
  5. Internet Explorer form automation from Excel
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2010, 08:04 AM
  6. Using Excel to Complete Form in Internet Explorer
    By ShannonLarson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2007, 09:28 AM
  7. "Export to Excel" doesn't appear in Internet Explorer
    By logicada in forum Excel General
    Replies: 1
    Last Post: 11-07-2005, 03:46 PM

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