Jim,
01. Using The Glorious R:BASE 2000 (ver 6.5++) for Windows:
GATEWAY EXPORT DB3P A:XLData.DBF SELECT * FROM TXLData
LAUNCH A:KeyMacro.XLS
No need to use ZIP command!
02. Using The R:edoubtable R:BASE 2000 (ver 6.5++) for DOS:
If using Win95/98/Me:
ZIP COMMAND.COM /C START Batchfile.bat
If using WinNT/2000:
ZIP CMD.EXE /C START Batchfile.bat
You could automate the detection of operating system by
using (ENVVAL('COMSPEC')).
Have Fun!
Very Best Regards,
Razzak.
At 03:50 PM 6/20/01 -0400, Jim Andrus wrote:
>GATEWAY EXPORT DB3P a:xldata.dbf SELECT ALL FROM txldata
>ZIP start "C:\Program Files\Microsoft Office\Office\EXCEL.EXE"
>A:keymacro.xls
>
>However, in DOS 6.5 (which I don't have access to but the client
>does) a RBase menu screen opens asking (not necessarily in the
>order I am listing them) Import or Export, file format, output
>format, table, columns, sort order, etc. The xldata.dbf file is
>then properly sent to A: where xlhead.txt already resides. Excel
>never opens so keymacro.xls is never called.
>
>1) Is there anyway all of the operator involvement required by
>DOS but not WIN can be eliminated?
>2) Why isn't the ZIP to Excel executed?
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
