Consulting

Results 1 to 5 of 5

Thread: suppressing warnings / data connections in word

  1. #1
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    5
    Location

    suppressing warnings / data connections in word

    Hi there

    I am opening word docs like so:

    Set wdObjDest = GetObject(strWordDocDest)

    If this word document is trying to connect to a datasource (for mail merge or what have you) then the code freezes until it brings up a warning message saying ''Microsoft Office Excel is waiting for another application to complete an OLE action".

    How do I bypass any data connection and open up the document regardless of whether it is a valid data connection?

    Many thanks

    Peter

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    Remove the connection in the Word document.
    If necessary you can establish the connection to the Word document in the VBA code in Excel.

  3. #3
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    5
    Location
    I am processing multiple documents, so can't go into everyone manually and remove the data connection.

    ta

  4. #4
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    You can do that in Word, using VBA.

  5. #5
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    5
    Location
    Thank you. I will look to see how to remove this.

Posting Permissions

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