• 0

Trouble with Excel Macro Auto Login


Question

techmikeprog

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 post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Copernic
      OfficeSuite 4.90.35798
      by Razvan Serea



      OfficeSuite is the smart choice for office productivity. Combining five feature-packed modules for work with Word, Excel, PowerPoint, PDF documents, and a Mail client with Calendar, OfficeSuite ensures you have all the tools necessary to succeed. You also get 5GB free storage on MobiDrive cloud and true cross-platform experience between your Windows PC and mobile devices to access your work and personal files anytime, anywhere.

      OfficeSuite is free to install and can be used to read, create, edit, and save documents. Do note that you'll need to purchase OfficeSuite Premium to print documents without a watermark, however.

      The major features of OfficeSuite are:

      OfficeSuite Documents - Creating documents with a beautiful design is easy and intuitive. All the necessary functions for the creation of documents are included for free. OfficeSuite Sheets - Create powerful and sophisticated spreadsheets, complete with graphs, formulas and great designs. OfficeSuite Slides - Create beautiful presentations that captivate audiences. Powerful transition, animation and design features are also included. OfficeSuite Mail & Calendar - Free of unnecessary functions, this is an easy to use mail client which includes a calendar. All the necessary features to manage your emails and agenda are available. PDF Extra Viewer - Convenient PDF viewer is also included. MobiSystems Drive - 5GB of Mobisystems cloud storage absolutely free. Files are automatically synchronized between devices on different platforms – Android, iOS & Windows. Full compatibility with Microsoft Office

      OfficeSuite offers extremely high compatibility with Microsoft Office and various popular file formats (Open Document, CSV and others). No need to convert and manipulate files – they can be opened and used right away by OfficeSuite. Cross-platform and cloud support – Work with any file, anywhere, anytime on any device.

      Your data gets automatically synchronized between Windows and mobile devices (Android and iOS), so you can keep on working while on the go. Documents, Spreadsheets, Presentations & Emails

      Powerful modules packed with helpful tools to handle any task. All the advanced features you need – format painter, track changes, conditional formatting, formulas, presentation mode, events calendar, email address book and much more. Familiar desktop interface to start working right away. Export Word, Excel, or PowerPoint documents to PDF. Advanced security options. What's new in OfficeSuite Slides 4.90.35634.0:

      Line Spacing in Paragraphs - We've added the Line Spacing feature in the Paragraph section of the ribbon to make it easier to use. Bug-fixes and Improvements - Continual improvements, making OfficeSuite Slides more polished and user-friendly. What's new in OfficeSuite Documents 4.90.35634.0:

      Improved Complex Script Support - Customize Theme fonts for East Asian and Complex Script languages. Text Box Function - We've made it possible to view and edit text in linked text boxes. What's new in OfficeSuite Sheets 4.90.35634.0:

      Text in Shapes - Use the context toolbar to quickly edit or format text in inserted shapes. Insert text Box - Add text boxes to key areas of your spreadsheet to leave important feedback. Improved Sum & Subtract - You can now use the Sum and Subtract formulas on minutes, hours and other time values. Note: OfficeSuite 4.90.35798 changelog is not yet available.

      Download: OfficeSuite 4.90.35798 | 3.1 MB (Freemium, Web Installer)
      View: OfficeSuite Website | Android | iOS | Windows Store | Screenshots

      Get alerted to all of our Software updates on Twitter at @NeowinSoftware

    • By News Staff
      Save 97% off the Premium 2021 Microsoft Excel & Data Certification Bundle
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 97% off the Premium 2021 Microsoft Excel & Data Certification Bundle. Kickstart your career as a Data Analyst with 90 hours of basic to advanced content on Microsoft Excel, Power BI, Tableau, VBA, Python and more.



      This bundle consists of the courses listed below:

      MS Excel/Excel 2020: The Complete Introduction to Excel
      Gain Basic Knowledge on How to Use Microsoft Excel

      Microsoft Excel: Intro to Power Query, Power Pivot & DAX
      Get Up & Running with Excel's Data Modeling & Business Intelligence Tools

      Excel Pro Tips: Data Visualization
      Think Outside the Pie Chart & Explore Some of Excel’s Most Powerful Visualization Tools

      Microsoft Excel: Advanced Formulas & Functions
      Master 75+ Excel Formula & Functions with Hands-On Demos

      Up & Running with Power BI Desktop
      Transform, Analyze & Visualize Data Using Microsoft Power BI Desktop

      Microsoft Excel: Data Analysis with Excel Pivot Tables
      Master Excel Pivot Tables & Pivot Charts with Hands-On Demos

      Microsoft Excel: Data Visualization with Excel Charts & Graphs
      Master 20+ Charts & Graphs in Excel with Hands-On Demos

      Microsoft Excel: Learn MS Excel for Data Analysis
      Use Excel for Data Analysis by Creating Your Own Excel Apps

      Microsoft Excel: Basic/Advanced Excel Formulas
      Learn More Than 80 Excel Functions, Formulas & Tips

      Project Finance Ninja Course
      Build Project Finance Models From Scratch & Discover Their Economic Feasibilit

      Power Query for Excel & Power BI
      2 Hours of Content on Power Query, Excel, BI, and SQL Server Data Tools

      Visual Storytelling with Power BI
      Learn Data Modeling Basics, Visualization & Analytics, and More

      Tableau Training & Certification
      Analyze Trends Visually & Make Quick Decisions with 3 Hours of Content on Tableau Essential

      Python for Finance
      Python Basics, Numpy, Pandas, Matplotlib, & More — Perform Financial Tasks Using Python

      Excel for HR Dashboard & Analytics
      AutomateExcel Tasks & Create a Powerful Analysis for HR and L&D Data on Real-Life Business Problems

      Excel for Sales Dashboard & Analytics
      Prepare Your Sales Reports & Perform Analytics

      DAX Made Easy
      Best of Data Analysis Expressions (DAX) for Beginners in 90 Minutes

      New Microsoft Excel & Office 365 Features
      Increase Your Productivity with All New MS Excel 2019 & Office 365 Features and Save Time!

      New Microsoft Excel & Office 365 Features
      Increase Your Productivity with All New MS Excel 2019 & Office 365 Features and Save Time!

      360° Financial Modeling & Valuation Course
      Learn Industry Best Practices & Common Pitfalls in Financial Modeling

      Alteryx Online Course
      Get Started with 25 Essential Alteryx Tools for Beginners

      Excel VBA Tutorials: Learn Excel Programming Language
      Automate Repetitive Tasks Using Excel VBA with Just One Click

      SAS Programming Online Course
      Become a Data Expert Using the SAS Data Science Tools

      Advanced Excel Crash Course
      Learn Excel Online for MIS Reporting, Data Cleaning, Data Analysis, Charting, & Time-Saver Tricks with Examples

      Good to know
      Length of time users can access this course: lifetime Certification of completion included Updates included Redemption deadline: redeem your code within 30 days of purchase For specifications and instructor info please click here.

      Here's the deal:
      This Premium 2021 Microsoft Excel & Data Certification Bundle normally costs $2,376, but can now be yours for just $69.99, for a limited time, that's a saving of $2,306.01 (97%) off!

      >> Learn more about it, or get this deal now <<
      See all Online Courses on offer. This is a time-limited offer that ends soon.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here, but be aware that these are all time-limited offers. If you are uncomfortable sharing your details with a third-party sponsor, we understand. Check out the Neowin Store for our preferred partners.



      The Win Your Dream 2020 Tesla Model 3 Giveaway Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% 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 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 Copernic
      WPS Office Free 11.2.0.9747
      by Razvan Serea



      WPS Office (formerly Kingsoft Office) is a high performing, yet considerably more affordable solution that is recognized as a preferred alternative to Micosoft Office and is fully compatible and comparable to Microsoft PowerPoint, Excel and Word. The WPS Office suite is available for Windows and Linux-based PCs as well as Android and iOS.

      Key features include:

      Writer - efficient word processor. Presentation -Multimedia presentations creator. Spreadsheets - Powerful tool for data processing and analysis. 100% compatible with MS Office document file types (.docx, .pptx, .xlsx, etc.). Thousands of free document templates. Built-in PDF reader. Free Templates - WPS Office offers a large number of free templates to help you create word documents, presentations, and spreadsheets to save you time. Mobile device support (iOS and Android). WPS Cloud Storage included. WPS Office Free 11.2.0.9747 changelog:

      PDF

      Optimized the experience of core usage scenarios: Highlight & Markup, Fill & Sign and Combine PDF. User Experience Improvement

      Fixed some crashes and improved program stability. Download: WPS Office Free 11.2.0.9747 | Store | 150.0 MB (Free, paid upgrade available)
      View: WPS Office Homepage | Android | Mac | Linux | iOS | Screenshot

      Get alerted to all of our Software updates on Twitter at @NeowinSoftware

    • By Copernic
      OfficeSuite 4.90.35634
      by Razvan Serea



      OfficeSuite is the smart choice for office productivity. Combining five feature-packed modules for work with Word, Excel, PowerPoint, PDF documents, and a Mail client with Calendar, OfficeSuite ensures you have all the tools necessary to succeed. You also get 5GB free storage on MobiDrive cloud and true cross-platform experience between your Windows PC and mobile devices to access your work and personal files anytime, anywhere.

      OfficeSuite is free to install and can be used to read, create, edit, and save documents. Do note that you'll need to purchase OfficeSuite Premium to print documents without a watermark, however.

      The major features of OfficeSuite are:

      OfficeSuite Documents - Creating documents with a beautiful design is easy and intuitive. All the necessary functions for the creation of documents are included for free. OfficeSuite Sheets - Create powerful and sophisticated spreadsheets, complete with graphs, formulas and great designs. OfficeSuite Slides - Create beautiful presentations that captivate audiences. Powerful transition, animation and design features are also included. OfficeSuite Mail & Calendar - Free of unnecessary functions, this is an easy to use mail client which includes a calendar. All the necessary features to manage your emails and agenda are available. PDF Extra Viewer - Convenient PDF viewer is also included. MobiSystems Drive - 5GB of Mobisystems cloud storage absolutely free. Files are automatically synchronized between devices on different platforms – Android, iOS & Windows. Full compatibility with Microsoft Office

      OfficeSuite offers extremely high compatibility with Microsoft Office and various popular file formats (Open Document, CSV and others). No need to convert and manipulate files – they can be opened and used right away by OfficeSuite. Cross-platform and cloud support – Work with any file, anywhere, anytime on any device.

      Your data gets automatically synchronized between Windows and mobile devices (Android and iOS), so you can keep on working while on the go. Documents, Spreadsheets, Presentations & Emails

      Powerful modules packed with helpful tools to handle any task. All the advanced features you need – format painter, track changes, conditional formatting, formulas, presentation mode, events calendar, email address book and much more. Familiar desktop interface to start working right away. Export Word, Excel, or PowerPoint documents to PDF. Advanced security options. What's new in OfficeSuite Slides 4.90.35634.0:

      Line Spacing in Paragraphs - We've added the Line Spacing feature in the Paragraph section of the ribbon to make it easier to use. Bug-fixes and Improvements - Continual improvements, making OfficeSuite Slides more polished and user-friendly. What's new in OfficeSuite Documents 4.90.35634.0:

      Improved Complex Script Support - Customize Theme fonts for East Asian and Complex Script languages. Text Box Function - We've made it possible to view and edit text in linked text boxes. What's new in OfficeSuite Sheets 4.90.35634.0:

      Text in Shapes - Use the context toolbar to quickly edit or format text in inserted shapes. Insert text Box - Add text boxes to key areas of your spreadsheet to leave important feedback. Improved Sum & Subtract - You can now use the Sum and Subtract formulas on minutes, hours and other time values. Download: OfficeSuite 4.90.35634 | 3.1 MB (Freemium, Web Installer)
      View: OfficeSuite Website | Android | iOS | Windows Store | Screenshots

      Get alerted to all of our Software updates on Twitter at @NeowinSoftware

    • By News Staff
      Microsoft Office 2019 -- Free Reference Card Bundle
      by Steven Parker

      Claim your free reference guide today, before this offer expires.



      This Microsoft Office 2019 reference bundle includes individual reference cards providing shortcuts, tips, and tricks for the most popular office productivity suite in the world.

      Use the reference cards to brush up on the basics and/or find alternative methods to your favorite commands. Each reference card is designed to be printable and are yours to use, distribute, and share at your organization!

      The 7 Reference Cards Included in this Bundle:

      Excel OneNote Outlook PowerPoint Teams Windows 10 Word 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. While supplies last!

      >> Microsoft Office 2019 -- Free Reference Card Bundle <<
      Offered by CustomGuide, view other free resources | Limited time offer

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here, but be aware that these are all time-limited offers. If you are uncomfortable sharing your details with a third-party sponsor, we understand. Check out the Neowin Store for our preferred partners.



      The Win Your Dream 2020 Tesla Model 3 Giveaway Ivacy VPN - 5 year subscription for just $0.99 per month NordVPN - 2-year plan 68% off +3 months for free (total of 27 months) Private Internet Access VPN - subscriptions at up to 71% 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 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.