Date:         Thu, 28 Sep 2000 10:34:40 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      writing to a different worksheet in an excel file than the first
              one
Comments: To: einer.einer@gmx.net
Content-type: text/plain; charset=iso-8859-1

In a winXX sas session, look at the dde triplet (at least on v6 that could be obtained via menu items Options >> DDE triplet
(I copy that into the paste buffer with Ctrx+C, but I expect there are parts of the menu to support gui-copy-by-mouse)
Then paste the triplet into an editor.
In this example
Excel|C:\DATA\sas\[DomainTables_v4.0.xls]D39_GCRM_ERF!R1C1:R2C3
what appears between the "[" and "]" is the workbook name
what appears after the "]" and before the "!" is the sheet name

You can use the (in)file option FILEVAR to dynamically change the target for the (in)file statement.




Datum:         28/09/2000 08:20
An:            SAS-L@listserv.uga.edu




Antwort an:    einer.einer@gmx.net

Betreff:       writing to a different worksheet in an excel file than the first              one
Nachrichtentext:


Hi,

i need to export data to an excel-file, how can i write into the second,
third, ... worksheet in the file? I did not find any useful option...

Regards
Sebastian





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.