Lynn McGuire wrote :
Hi,

I am creating Excel spreadsheets from our application. We start
Excel and then send DDE commands to it to create spreadsheets.
Is there a better way of doing this that is not so error prone ?

Excel seems to have DDE problems often and there seems to be some
mysterious re-entrency problems where both our application and
Excel will have be restarted in order to get the communication
flowing again.

Sincerely,
Lynn McGuire

What application are you using? If it's VB or one of the M$.Net apps
then it likely has what you need for automation via a CreateObject()
type of function. Once created and an object ref established, you can
send VB[A} commands to manipulate the Excel instance however required
by your app. This can happen whether Excel is visible or not, not
visible being the default state of an automated instance.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc