Consulting

Results 1 to 2 of 2

Thread: VBA: Workbook won't open until the macro is completely finished

  1. #1
    VBAX Regular
    Joined
    Feb 2018
    Posts
    17
    Location

    VBA: Workbook won't open until the macro is completely finished

    I have macro that opens a workbook file in a website, the problem is the workbook won't open until my code is finished. I tried looping until the workbook opens but the macro just ends up in an infinite loop. Application.Wait also wont work. Hoping someone can help

  2. #2
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,198
    Location
    Might help to see the code.

    First thoughts would be maybe you have a screen updating set to true, really need to see the code though.
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2403, Build 17425.20146

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •