Consulting

Results 1 to 6 of 6

Thread: Opening a Word document from VBA shows Microsoft Sign In page

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Feb 2013
    Posts
    4
    Location

    Opening a Word document from VBA shows Microsoft Sign In page

    When I open certain Word documents in Word (or Excel) VBA, the Microsoft sign in page shows up (see below). However, if I just double click on the file from Windows Explorer, the file opens just fine without showing this sign in page. Also, if I manually exit the popup window the document loads without any issue. This only happens on certain documents but the sign in page halts the macro.

    Any ideas as to why this is happening and how to stop it?

    I have tried almost everything listed on forums. Deleting credentials, logged into Office, etc.


    Thanks,


    Mark

    Document Download Link from Source: https://portal.3gpp.org/ngppapp/Crea...utionId=867945


    Code Segment:

    Dim wdApp As Word.Application
       
    Set wdApp = New Word.Application
    wdApp.Visible = True
       
    Dim wd As Word.document 
    Set wd = wdApp.Documents.Open(doc)


    Last edited by markinca; 10-09-2018 at 12:21 PM.

Posting Permissions

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