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,
From: Non-HP-MishKS /HP-USA,mimegw5/dd.HPMEXT1=MishKS@NSWC.NAVY.MIL
Sent: Friday, April 09, 1999 12:47 PM
Cc: Non-HP-MishKS /HP-USA,mimegw5/dd.HPMEXT1=MishKS@NSWC.NAVY.MIL
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,