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 readsDisplay More
- Sub labelprint2()
- ' Save Excel
- ' Start Word
- Dim objWord As Object
- Set objWord = CreateObject('Word.application')
- ' Open Word Document
- objWord.Documents.Open Filename:='Svr1lampandgearusersAlecPipelineMerge2.doc'
- objWord.Visible = True
- ' Print Word Document
- ' Close and Save Word Document
- objWord.ActiveDocument.Close savechanges:=True
- Set objWord = Nothing
- 'Close Word
- End Sub
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:
- Current Location
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.