Word Could Not Re Establish A Dde Connection To Microsoft

понедельник 17 февраляadmin
Word Could Not Re Establish A Dde Connection To Microsoft Rating: 8,4/10 9279 reviews
  • Points
    655
    Posts
    75

    Help......


    I have spent half today setting up an automated label print mail merge from an excel worksheet. This all singing all dancing macro was controlled by a button on the worksheet.

    Fujitsu fp 410 driver win7. PartnumberOperating SystemFile (Zip)VersionFTP-627DSL6xxWindows®10 - 32-bit6x7uv320Windows®10 - 64-bit575KB6x7uv320FTP-628DSL6xxWindows®10 - 32-bit6x7uv320Windows®10 - 64-bit6x7uv320FTP-628WSL2xxWindows®10 - 32-bit628wslv320Windows®10 - 64-bit224KB628wslv320FTP-629DSL35xWindows®10 - 32-bit6x9uv320Windows®10 - 64-bit6x9uv320FTP-62GDSL001Windows®10- 32-bit6xguv322Windows®10 - 64-bit6xguv321FTP-639USL1xxWindows®10 - 32-bit6x9uv320Windows®10 - 64-bit6x9uv320FTP-639USL2xxWindows®10 - 32-bit6x9uv320Windows®10 - 64-bit6x9uv320. Controller BoardPartnumberOperating SystemNotesFTP-622DCL/DSLxxxFTP-622DCL/DSL1xxFTP-624DCL/DSLxxxFTP-627DCL/DSL2xxFTP-627DSL6xxFTP-627USL4xxFTP-628DCL/DSL2xxFTP-628DCL/DSL3xxFTP-628DCL/DSL45xFTP-628DSL6xxFTP-628WSL1xxFTP-629DCL/DSLxxxFTP-629DSL1xxFTP-629DSL2xxFTP-629DSL3xxFTP-639USL002RedHat 7.1/7.2/8/9Fedora Core 1/2/3/4/9/10Vine Linux 2.5Turbo Linux 7/10Laser5 7.1Miracle Linux 2.1SUSE Linux 10.1/10.2Omoikane GNU2.0Kondara GNU 2.1Debian 2.0/2.1CentOS 5.2/5.3Linux drivers are are available to our customers by request; please for details.


    Following exhaustive testing (including using a whole printer cartidge and 1/2 ream of paper) I called my boss over to show off the fruits of my endeavours.


    The button is pressed and.....


    I Quote 'Word could not re-establish a DDE connection to Microsoft Excel to complete the current task'


    After my boss had stopped laughing he asked if it was 'supposed to do that' and 'Would I like to go on an Excel for muppets course'


    Needless to say this issue is now on a global lvl of importance and must be resolved asap.


    My code reads


    1. Sub labelprint2()
    2. ' Save Excel
    3. ActiveWorkbook.Save
    4. ' Start Word
    5. Dim objWord As Object
    6. Set objWord = CreateObject('Word.application')
    7. ' Open Word Document
    8. objWord.Documents.Open Filename:='Svr1lampandgearusersAlecPipelineMerge2.doc'
    9. objWord.Visible = True
    10. ' Print Word Document
    11. objWord.Application.PrintOut
    12. ' Close and Save Word Document
    13. objWord.ActiveDocument.Close savechanges:=True
    14. Set objWord = Nothing
    15. 'Close Word
    16. objWord.Application.Quit
    17. End Sub
    Display More


    Help please...... :crying:



    By the way, I haver still not resolved my earlier issue of having to select 'read only' when Word tries to re-open the Excel sheet.



    Thanks in advance


    Red faced Alec. :poly:

    1. Navigation
    2. OzGrid
    3. Forum
    4. Members
    5. Options
    6. Current Location
    This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
    Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
Can establish dde connection excel

Word could not re-establish a DDE connection to program name to complete the current task. You may receive the same error message when you insert a. Click the Microsoft Office Button, and then click Word Options.