Thank you everyone for your help. My questions were answered and then some.
Kevin Mish
> -----Original Message-----
> From: Mish Kevin S DLVA
> Sent: Friday, April 09, 1999 11:47 AM
> To: 'hpvxd_xc@hpislsup.lvld.hp.com'
> Subject: VRF-need_help_with_DDE
>
> Hello.
>
> I'm writing a HP VEE program that will open an Excel spreadsheet,
> dump data into it, then request a filename and save the spreadsheet
> as that filename.
>
> The only part I cannot determine is the command used for "SaveAs"
> in Excel through the DDE.
>
> Can anyone help?
>
> Thanks in advance,
> Kevin Mish
> mishks@nswc.navy.mil
Kevin Mish
> -----Original Message-----
> From: Mish Kevin S DLVA
> Sent: Friday, April 09, 1999 11:47 AM
> To: 'hpvxd_xc@hpislsup.lvld.hp.com'
> Subject: VRF-need_help_with_DDE
>
> Hello.
>
> I'm writing a HP VEE program that will open an Excel spreadsheet,
> dump data into it, then request a filename and save the spreadsheet
> as that filename.
>
> The only part I cannot determine is the command used for "SaveAs"
> in Excel through the DDE.
>
> Can anyone help?
>
> Thanks in advance,
> Kevin Mish
> mishks@nswc.navy.mil
Kevin,
What you will need to do is an execute for the DDE transaction with
the following for the command "[SAVE.AS("filename.xls")]" . The
backslashes in the command embed double quotes (") around the filename.
Filename could be replaced with an input variable by using the following
syntax "[SAVE.AS("" + A + "")]"
Hope this helps,
Lyle Carnahan
Hewlett-Packard
lyle_carnahan@hp.com
-----Original Message-----
From: Non-HP-MishKS /HP-USA,mimegw5/dd.HPMEXT1=MishKS@NSWC.NAVY.MIL
Sent: Friday, April 09, 1999 12:47 PM
To: hpvxd-xc-at-lvld
/HP-USA,mimegw5/dd.HPMEXT1=hpvxd_xc@hpislsup.lvld.hp.com
Cc: Non-HP-MishKS /HP-USA,mimegw5/dd.HPMEXT1=MishKS@NSWC.NAVY.MIL
Subject: VRF-need_help_with_DDE
Hello.
I'm writing a HP VEE program that will open an Excel spreadsheet,
dump data into it, then request a filename and save the spreadsheet
as that filename.
The only part I cannot determine is the command used for "SaveAs"
in Excel through the DDE.
Can anyone help?
Thanks in advance,
Kevin Mish
mishks@nswc.navy.mil