• 0

Trouble with Excel Macro Auto Login


 Share

Question

I have been trying to use a Macro in VBA/Microsoft Excel to auto login to a web site automatically and fill in information into the web page.  On the up side I'm able to do this on several different web sites (google, hotmail, etc); however, when I attempt to log in to a couple in particular web sites I receive an error.  The message reads:

 

"System Error &H80010108 (-2147417848). The object invoked has disconnected from its client."

 

 

Again, I know the code is close to correct because this works on several web pages, but a couple others time out.  After several days of researching I'm still not any closer to a solution.  When running the code line-by-line, it appears as though VBA/Excel is loosing the webpage.  I'm not sure if it's because the web site is encrypted or something else may be going on.

 

I've attached the code below and commented where the problem is.  Do you have any thoughts why I may be having issues with this web site?  Any thoughts would be greatly appreciated!!!

 

-Thanks

 

 

 

*****VBA SCRIPT*****

_______________________________

Sub WebPageStartup()

 

Dim IE As Object

 

Set IE = CreateObject("InternetExplorer.Application")

IE.Visible = True

 

IE.navigate "https://enterpriseportal.disney.com"

 

Do                         '-Begins the problem when waiting for ready state to be complete

DoEvents

Loop Until IE.readyState = 4

 

HTMLDoc.all.USER.Value = "abc"

HTMLDoc.all.PASSWORD.Value = "123"

IE.document.getElementById("Enter").Click

 

End Sub

_______________________________

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By News Staff
      Pay What You Want and get the 2021 Essential Excel Wizard Bundle
      by Steven Parker



      Today's highlighted offer comes via our Online Courses section of the Neowin Deals store, where you can Pay What You Want for the Essential 2021 Excel Wizard Bundle. This 14+ hours of training will take you from zero to hero in Microsoft Excel dynamic formulas, functions, api reporting and more.

      Unlock the following courses with a minimum of the average price:

      Excel Magic 1: Build Dynamic Formulas with Excel
      Learn Intermediate toA Advanced Excell Skills that Will Help You Become a Professional

      Excel Magic 2: Build Your Own Report Generating Bots with Excel
      Learn How to Build Your Own Report Generating Robot Through VBA

      Excel Magic 3: Automating Data Entry with Data Feeds
      Learn How to Automate Data Entry & How to Connect to Sources to Obtain Real-Time Updates of Data

      Excel Magic 4: Ultimate API Reporting in Excel
      Understand the Idea of API Reporting & Generate Low-Maintenance Full-Automated Financial Reports

      Excel Magic 5: Building Interactive Budgeting Model in Excel
      Build an Interactive Model in Excel & Explore Methods to Consolidate Actuals and Budgets

      Must-Know Formulas & Functions in Excel
      Know the Most Popular Formulas & Functions in Excel & Learn How to Use Them

      Getting Results with Excel Pivot Tables, Power Query & Power Pivot
      Learn How to Analyze Rows of Data in Excel, Power Query & Power Pivot

      Excel Magic Part 6: Speaking the 7 Languages in Excel
      Mastering Excel's Programming Language & Be an Expert User of Them

      Learn to Use the Top 50 Microsoft Excel Formulas in 50 Minutes
      Learn the Basics of Microsoft Excel & Its Often Used Formulas

      Pay What You Want (as little as $1) for the unlocked courses:

      Using VLOOKUP, XLOOKUP & Other Functions
      Learn About VLOOKUP, XLOOKUP & HLOOKUP and Know How to Link Sheets & Consolidate Data

      Excel Pivot Table: How to Tame the Excel Beast
      18 Taming Manuevers for Pivot Tables That You Have to Be Aware of

      Here's the deal:
      The full bundle represents an overall retail value of $2,189. To unlock the full bundle is around $11.50 at the time of writing. Beat the average price and you'll take home the entire bundle. Beat the Leader's price and get entered into the epic giveaway. Pay What You Want for Essential 2021 Excel Wizard Bundle
      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto | Gaming Bundle Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Free Download: 101 Best Excel Tips & Tricks guide
      by Steven Parker

      Thanks to our partners, you can request your free guide. Do it now before the offer expires.



      What's it about?


      The BEST Microsoft Excel Tips & Tricks EVER, ranging from Formatting, Macros, Formulas, Tables, Pivot Tables, Working with Data plus Many More!

      Easy to Read Step by Step Guide with Color Screenshots PLUS an Interactive & Searchable PDF E-Book to find any Excel Tip & Trick with ease!

      Downloadable Practice Excel Workbooks for each Tip & Trick!

      How to get it
      Please ensure you read the terms and conditions to claim this offer. Complete and verifiable information is required in order to receive this free offer. If you have previously made use of these free offers, you will not need to re-register. Offered by MyExcelOnline.com, view their other free resources. Limited time offer.

      Get 101 Best Excel Tips & Tricks - Free Download
      Not for you?
      That's OK, there are other free eBooks on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Apple Giveaway | Gaming Giveaway | Amazon Giveaway Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      Disclosure: A valid email address is required to fulfill your request. Complete and verifiable information is required in order to receive this offer. By submitting a request, your information is subject to TradePub.com's Privacy Policy.



    • By News Staff
      Pay What You Want for this 2021 Essential Excel Wizard Bundle
      by Steven Parker



      Today's highlighted offer comes via our Online Courses section of the Neowin Deals store, where you can Pay What You Want for the Essential 2021 Excel Wizard Bundle. This 14+ hours of training will take you from zero to hero in Microsoft Excel dynamic formulas, functions, api reporting and more.

      Unlock the following courses with a minimum of the average price:

      Excel Magic 1: Build Dynamic Formulas with Excel
      Learn Intermediate toA Advanced Excell Skills that Will Help You Become a Professional

      Excel Magic 2: Build Your Own Report Generating Bots with Excel
      Learn How to Build Your Own Report Generating Robot Through VBA

      Excel Magic 3: Automating Data Entry with Data Feeds
      Learn How to Automate Data Entry & How to Connect to Sources to Obtain Real-Time Updates of Data

      Excel Magic 4: Ultimate API Reporting in Excel
      Understand the Idea of API Reporting & Generate Low-Maintenance Full-Automated Financial Reports

      Excel Magic 5: Building Interactive Budgeting Model in Excel
      Build an Interactive Model in Excel & Explore Methods to Consolidate Actuals and Budgets

      Must-Know Formulas & Functions in Excel
      Know the Most Popular Formulas & Functions in Excel & Learn How to Use Them

      Getting Results with Excel Pivot Tables, Power Query & Power Pivot
      Learn How to Analyze Rows of Data in Excel, Power Query & Power Pivot

      Excel Magic Part 6: Speaking the 7 Languages in Excel
      Mastering Excel's Programming Language & Be an Expert User of Them

      Learn to Use the Top 50 Microsoft Excel Formulas in 50 Minutes
      Learn the Basics of Microsoft Excel & Its Often Used Formulas

      Pay What You Want (as little as $1) for the unlocked courses:

      Using VLOOKUP, XLOOKUP & Other Functions
      Learn About VLOOKUP, XLOOKUP & HLOOKUP and Know How to Link Sheets & Consolidate Data

      Excel Pivot Table: How to Tame the Excel Beast
      18 Taming Manuevers for Pivot Tables That You Have to Be Aware of

      Here's the deal:
      The full bundle represents an overall retail value of $2,189. To unlock the full bundle is around $11.50 at the time of writing. Beat the average price and you'll take home the entire bundle. Beat the Leader's price and get entered into the epic giveaway. Get this Essential 2021 Excel Wizard Bundle
      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto | Gaming Bundle Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Learn AutoCAD Programming with this Certification Bundle for just $29.99
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store where you can save 98% off this Learn AutoCAD Programming Certification Bundle. Become an AutoCAD Wizard with 67 hours of hands-on lectures on VBA, VB.NET, C#, AutoLISP, and C#.NET Programming.



      This bundle consists of the following courses:

      Learn AutoCAD Programming using VB.NET - Hands On!
      Gain Confidence to Create Your Own AutoCAD Plugin using VB.NET Programming AutoCAD VBA Programming - Beginner Course
      Gain a Solid Understanding of AutoCAD VBA Concepts & Fundamentals to Develop Your Own Applications AutoCAD to Excel - VBA Programming Hands-On!
      Learn How to Export & Import AutoCAD Drawings to Excel to Other Formats through VBA Programming AutoCAD Programming using C# with Windows Forms
      Learn AutoCAD Programming through C# by Developing Real World Applications Develop AutoCAD Plugins using VB.NET with Windows Forms
      Pick Up How to Develop AutoCAD Plugins using VB.NET with Windows Forms Programming AutoCAD to Excel using VB.NET - Hands-On!
      Develop AutoCAD Plugins that integrate with Excel & Text Files using VB.NET Practical AutoLISP Programming - Beginner to Advanced
      Learn from This Ultimate AutoLISP Programming Guide with Lots of Sample Programs AutoCAD Programming using C#.NET - Beginner Course
      Master The Fundamentals of C# Programming & Create AutoCAD Objects Through this Ultimate Guide Here's the deal:
      This Learn AutoCAD Programming Certification Bundle normally costs $1600 but it can be yours for just $29.99 for a limited time, that's a saving of $1570.01 (98%) off the price. For a full description, specs, and instructor info please click the link below.

      Learn AutoCAD Programming Certification Bundle just $29.99
      Save 13% off this 20W Mini USB-C PD Charger
      From 0 to 50% in Just 30 Minutes! Fast Charge Your iOS Device on Any Plug with This 20W Charger, Plus an Extra USB-C PD to Lightning Cable.

      Get the ZeroLemon Mini Charger for just $19.99 (list price $22) 13% off

      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Apple Giveaway | Gaming Giveaway | Amazon Giveaway Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      You Can Pay What You Want for the Essential 2021 Excel Wizard Bundle
      by Steven Parker



      Today's highlighted offer comes via our Online Courses section of the Neowin Deals store, where you can Pay What You Want for the Essential 2021 Excel Wizard Bundle. This 14+ hours of training will take you from zero to hero in Microsoft Excel dynamic formulas, functions, api reporting and more.

      Unlock the following courses with a minimum of the average price:

      Excel Magic 1: Build Dynamic Formulas with Excel
      Learn Intermediate toA Advanced Excell Skills that Will Help You Become a Professional

      Excel Magic 2: Build Your Own Report Generating Bots with Excel
      Learn How to Build Your Own Report Generating Robot Through VBA

      Excel Magic 3: Automating Data Entry with Data Feeds
      Learn How to Automate Data Entry & How to Connect to Sources to Obtain Real-Time Updates of Data

      Excel Magic 4: Ultimate API Reporting in Excel
      Understand the Idea of API Reporting & Generate Low-Maintenance Full-Automated Financial Reports

      Excel Magic 5: Building Interactive Budgeting Model in Excel
      Build an Interactive Model in Excel & Explore Methods to Consolidate Actuals and Budgets

      Must-Know Formulas & Functions in Excel
      Know the Most Popular Formulas & Functions in Excel & Learn How to Use Them

      Getting Results with Excel Pivot Tables, Power Query & Power Pivot
      Learn How to Analyze Rows of Data in Excel, Power Query & Power Pivot

      Excel Magic Part 6: Speaking the 7 Languages in Excel
      Mastering Excel's Programming Language & Be an Expert User of Them

      Learn to Use the Top 50 Microsoft Excel Formulas in 50 Minutes
      Learn the Basics of Microsoft Excel & Its Often Used Formulas

      Pay What You Want (as little as $1) for the unlocked courses:

      Using VLOOKUP, XLOOKUP & Other Functions
      Learn About VLOOKUP, XLOOKUP & HLOOKUP and Know How to Link Sheets & Consolidate Data

      Excel Pivot Table: How to Tame the Excel Beast
      18 Taming Manuevers for Pivot Tables That You Have to Be Aware of

      Here's the deal:
      The full bundle represents an overall retail value of $2,189. To unlock the full bundle is under $11.50 at the time of writing. Beat the average price and you'll take home the entire bundle. Beat the Leader's price and get entered into the epic giveaway. Get this Essential 2021 Excel Wizard Bundle
      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto | Gaming Bundle Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.