|
Steve proceeded:
> 1:
> system('start excel'); *what other commands besides 'start x'
> are there?;
Well, 'start' is a DOSv7 command. There's a really cool site
documenting the syntax of these:
http://www3.sympatico.ca/rhwatson/dos7/
However, as I'm only a very moderate user of DOS commands -- that
is: I try to avoid DOS as much as possible :-) -- perhaps someone
else here might suggest a couple of other ones (apart from 'start')
that have potential uses for us SAS geeks?
> 2:
> filename xlscmd dde 'excel|system';
> ...
> PUT '[??????????]' *want to insert a new worksheet;
> I tried recording marcos and using the observed commands, but
> after HOURS
> finally found a SAS note: ... must send Excel 4.x macro
> command. No one has
> Excel 4.x anymore, so where do I find these commands documented?
Ah, this is heading into more familiar territory ... I'd recommend
a read of Denslow and Li (SUGI26, 2001) who provide an in-depth dis-
cussion on importing data from Excel spreadsheets via DDE, and,
err... , Vyverman (SUGI26, 2001) for some general Excel spreadsheet-
handling tricks from within base SAS:
http://www2.sas.com/proceedings/sugi26/p029-26.pdf
http://www2.sas.com/proceedings/sugi26/p011-26.pdf
These papers contain numerous code samples, lots of further referen-
ces, _and_ instructions on how to download the Excel4 macro command
help file from the MS tech support site. Specifically, you'll find
info on inserting and (re)naming sheets in the latter.
Kind Regards,
Koen.
---------------------------------
Koen Vyverman
Database Marketing Manager
Fidelity Investments - Luxembourg
---------------------------------
| 
