• 0

Trouble with Excel Macro Auto Login

Asked by techmikeprog,

 Share

Question

Neowinian

techmikeprog

Posted
Posted

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
https://www.neowin.net/forum/topic/1334184-trouble-with-excel-macro-auto-login/
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
Go to question listing

  • Posts

    • Movavi Video Editor Plus 25.12.0

      By Copernic · Posted

      Movavi Video Editor Plus 25.12.0 by Razvan Serea With Movavi Video Editor, you can either enhance your video files with two or three simple steps, or turn them into something completely new. Create your own movies using multiple filters, transitions, and special effects: show multiple videos on one screen with the Picture in picture effect or change the background with the Chroma Key effect, imitate the camera zoom or make your video look like an old-style movie. Adjust video parameters such as brightness, contrast and colors. Stabilize shaky footage, improve video quality and remove defects. Create video presentations, tutorials or educational videos: add titles and record your own narration to create a video with voiceover. Import video from any source: TV-tuner, webcam, camcorder, or VHS. Drop multiple media files onto a timeline and let your imagination do the rest! Features at a glance: Video and audio editing on a timeline Edit, enhance videos Add background music Apply titles and effects Image quality improvement Hollywood-worthy effects High-grade titles and fades Digitize VHS tapes, record video from TV tuners Stabilize any shaky sections Support for a wide range of formats Prepare your videos for uploading to YouTube, Facebook, Vimeo, or any other website New in Movavi Video Editor 2025: Revamped timeline for easier editing The new timeline is now clearer and more streamlined. Get your projects done faster and have more fun with anything – from short vids for socials to longer family movies. Frame-precise cuts in a click Give your videos a sharper look with the new Blade tool. Easily make precise cuts and create eye-catching montages like your favorite bloggers. Pro-quality color correction Get next-level color correction with the same simplicity. Boost colors in a snap and make more viewers fall in love with your videos. AI motion tracking Enhance reality in your videos with additional moving graphics. Just click, and AI will quickly attach any photos, videos, emojis, or memes to objects in your footage. Perfect-match overlay effects Now each overlay effect has 13 blending modes to choose from. Try each of them with the press of a button and pick the one that fits your video perfectly. Best video effects – at your fingertips Create awesome videos in any style with our huge collection of professionally designed effects. Now you can try them all right away, right in the app. Movavi Video Editor 25.12.0 changelog: Just a minor upgrade to keep everything running smoothly. Download: Movavi Video Editor Plus 25.12.0 | 5.1 MB (Shareware) View: Movavi Video Editor Plus Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • Major Privacy 0.98.3 Beta

      By Copernic · Posted

      Major Privacy 0.98.3 Beta by Razvan Serea MajorPrivacy is a cutting-edge privacy and security tool for Windows, offering unparalleled control over process behavior, file access, and network communication. It is a continuation of the PrivateWin10 project. By leveraging advanced kernel-level protections, MajorPrivacy creates a secure environment where user data and system integrity are fully safeguarded. Unlike traditional tools, MajorPrivacy introduces innovative protection methods that ensure mounted encrypted volumes are only accessible by authorized applications, making it the first and only encryption solution of its kind. MajorPrivacy – Ultimate Privacy & Security for Windows key features Process Protection – Isolate processes to block interference from unauthorized apps, even with admin privileges. Software Restriction – Block unwanted apps and DLLs to ensure only trusted software runs. Revolutionary Encrypted Volumes Secure Storage – Create encrypted disk images for sensitive data. Exclusive Access – Unlike traditional tools, only authorized apps can access mounted volumes—blocking all unauthorized processes. File & Folder Protection – Lock down sensitive files and prevent unauthorized access or modifications. Advanced Network Firewall – Control which apps can send or receive data online. DNS Monitoring & Filtering – Track domain access and block unwanted sites (Pi-hole compatible filtering coming soon). Tweak Engine – Disable telemetry, cloud integration, and invasive Windows features for better privacy. Why MajorPrivacy? Kernel-Level Security – Protects at the deepest system level. Unmatched Encryption Protection – Keeps mounted volumes safe from all unauthorized access. Full System Control – Block, isolate, or restrict processes as needed. Enhanced Privacy – Stops Windows & apps from collecting unnecessary data. Perfect for privacy-conscious users, IT pros, and anyone who wants total system control. Major Privacy 0.98.3 Beta changelog: This release of MajorPrivacy introduces several important improvements, bug fixes, and optimizations. The resource access rules engine has been enhanced to include the user as an additional parameter, enabling finer-grained access control. CPU usage has been reduced in both the user interface and background service, improving overall performance. The ImBox feature has been updated to avoid modifying container file timestamps when accessing secure encrypted volumes. Firewall rule handling has been improved for Store Apps on Windows 23H2 and later versions, increasing compatibility and reliability. A critical issue has been resolved in ImBox.exe that affects the mounting of older encrypted volumes; users should use a previous build to recover data and then recreate the volumes using this or a later version. Additionally, several interface and functionality bugs have been addressed: translations now load correctly, the Data Editor’s tree view now functions properly across multiple .dat files, and the Execution Monitor displays entries as expected when a time filter is applied. The “Add to Group” menu now correctly lists all available groups, and folder creation is no longer incorrectly permitted under Directory Listing and Read-only actions. Download: Major Privacy 0.98.3 Beta | 59.4 MB (Open Source) View: MajorPrivacy Home Page | Github Project page | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • WordPress-Theme Twenty Twenty Four-customizing: how to do that - a Gutenberg special question...

      By zayanhani · Posted

      Hi there! Great question and yes, the Twenty Twenty-Four theme (TT4) + Gutenberg does have a few quirks when it comes to spacing and columns. To reduce the spacing between the image and the text in a two-column layout, here are a few things to try:  1. Adjust Block Spacing (Direct Method) Click on the Column Block (the outer wrapper that holds both your image and text). In the right sidebar, under "Block" > "Dimensions", look for the "Block spacing" setting (sometimes called “Gap”). Reduce the value (in px, em, or %) to tighten the space between elements inside that column. 2. Use Padding & Margin Controls Click on the Image block, and then the Text block individually. Under “Dimensions”, adjust the Margin of the Image or Text block (especially bottom or top margin) to reduce extra white space. Try setting margins to 0 or a small number like 8px. 3. Use Group Block (Optional) If the spacing controls aren’t behaving: Wrap the image + text inside a Group block. Then apply padding/margin settings to the inner blocks for better control.
    • Game I've been Working On

      By +InsaneNutter · Posted

      Looks interesting, I love the art style. How many people are working on the game?
    • AMD releases driver 25.8.1 with support for new RX 9060, new games, and more

      By TarasBuria · Posted

      AMD releases driver 25.8.1 with support for new RX 9060, new games, and more by Taras Buria AMD has a new driver for customers with Radeon graphics cards. Version 25.8.1 WHQL is now available with optimizations for more games and support for the new RX 9060 non-XT graphics card. The update also has plenty of fixed issues and bugs. Here are the update highlights: New Game Support New Game Support for FSR 4 Mafia: The Old Country Mecha BREAK WUCHANG: Fallen Feathers Valorant (Unreal Engine 5 release) Battlefield 6 Open Beta The Alters F1 25 Cyberpunk 2077 WUCHANG: Fallen Feathers Mafia: The Old Country Arena Breakout: Infinite Game of Thrones: Kingsroad Wreckfest 2 Lies of P Fixed issues and bugs include the following: Stutter and lower than expected performance may be observed while playing 4K resolution YouTube videos in Chrome. Intermittent application crash or driver timeout may be observed while playing Monster Hunter Wilds with Radeon Anti-Lag and Instant Replay enabled. Intermittent application crash may be observed while playing Battlefield 2042. Intermittent application crash may be observed while playing Dragon Age: The Veilguard on Radeon RX 9000 series graphics products. Stutter improved while playing Call of Duty: Warzone Season 03 ‘Verdansk’ map on some AMD Graphics Products NOTE: Stutter has been reduced with 25.8.1, and AMD is working with the developer toward a full solution. Texture issues may be observed while using Oculus Rift S on RX 5000 and 6000 series graphics products. And here is the list of known bugs: Corruption may appear while playing Mafia: The Old Country on Radeon RX 6600 series graphics products. Intermittent application crash may be observed while playing The Last of Us Part II on Radeon RX 7900 series graphics products. Intermittent application crash may be observed while playing Call of Duty: Black Ops 6 on Radeon RX 9000 series graphics products. Intermittent application crash or driver timeout may be observed while playing Wuchang: Fallen Feathers with FSR 4 enabled on Radeon™ RX 9000 series graphics products. Intermittent application crash may be observed while playing FBC: Firebreak on some AMD Ryzen processors such as the Ryzen AI 300 series and the Ryzen 7000 series. Intermittent application crash may be observed while playing NBA 2K26 in MyCareer mode on Radeon RX 9070 series graphics products. AMD Radeon Software 25.8.1 is available on 64-bit Windows 10 and 11 systems with supported Radeon graphics cards. You can download it from the official support website. Full release details are available on the same page.

  • Recent Achievements

    • Reacting Well
      water01 earned a badge
      Reacting Well
    • First Post
      Aidan Helfrich earned a badge
      First Post
    • Collaborator
      bullgod69 earned a badge
      Collaborator
    • Enthusiast
      Ed B went up a rank
      Enthusiast
    • Reacting Well
      Xinotema earned a badge
      Reacting Well

  • Popular Contributors

    1. 1
      +primortal
      763
    2. 2
      ATLien_0
      187
    3. 3
      +FloatingFatMan
      151
    4. 4
      Xenon
      118
    5. 5
      wakjak
      113
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!