AnsweredAssumed Answered

DDE using Excel

Question asked by VRFuser on May 20, 1997
I have to agree that the DDE process with Excel is very much trial and
error.  The documentation from Microsoft is almost nonexistent.

I have been able to get Excel to quit using the EXECUTE CMND:"[QUIT()]"
command.  However, it will return an error.  I think this is an Excel
problem.  I just add an ERROR output pin to the DDE box, and throw away
the error.  This seems to get around the problem.

Most of the Visual Basic for Applications commands can be sent to Excel
via DDE.  Excel processes a DDE call as a single-line macro.  If I'm
trying to do something complicated, I write a macro in Excel, and then
call the macro using DDE.

Hope this has been of some help.

Jeff Pahl
Space Systems Test Group
EMS Technologies, Inc.

>----------
>From:      Michael Kolos[SMTP:mkolos@sv.adi-ltd.com.au]
>Sent:      Wednesday, May 21, 1997 12:00 AM
>To:      'hpvxd_xc@hpislsup.lvld.hp.com'
>Subject:      VRf: DDE using Excel
>
>Has anyone successfully been able to quit Excel using a VEE DDE without
>error? The transaction I am using is (when the topic is set to SYSTEM):
>
>EXECUTE CMND:"[QUIT()]"
>
>Although I use the Microsoft Excel Function Reference, there is much trial
>and error on my part. I have got the following to work correctly and without
>error:
>
>EXECUTE CMND:"[PRINT("1")]"
>Prints the current worksheet, default everything else
>
>EXECUTE CMND:"[CLOSE("=FALSE")]"
>Closes the current workbook, no save (discards worksheet changes)
>
>I would appreciate anyone sharing their experience in using DDE under VEE
>
>Thanking you,
>
>Michael Kolos
>ADI Technology Group
>

Outcomes