Hi Joe Including range name definitions for output areas will eliminate NLS differences between foreign language editions of Excel ! Then sas meta data can associate the source data (sas data table columns) with excel range names (the destinations) with ...... a fileref (filename statement but not a filename function) for each range.

Although the fastest way to load the data might be to send commands to the excel system topic via dde to load/import from .csv data generated from sas, that will not support fast formatting. My experience with formatting was .... how simple it is when the recipients (or a user) prepare any required formatting in an empty workbook! Then dde just writes data into pre-formatted cells. Use the save.as dde- equivalent to save to a new workbook when all writing is complete.

Although it is possible for sas to manipulate cell formatting via dde, the excel interface for this seemed far simpler.

Regards Peter Crawford

Datum: 24/08/2001 15:24 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: "DeShon, Joe" <jdesho01@SPRINTSPECTRUM.COM>

Betreff: Writing to multiple Excel sheets Nachrichtentext:

We're experimenting with exporting SAS to Excel. One of our challenges is that PROC EXPORT will only write to one Excel sheet in a workbook. We need to create workbooks with multiple sheets. And we want to create them in SAS "Untouched by Human Hands".

I know of several ways of doing it, usually involving DDE or some combination of PROC EXPORT, DDE, VB, copy-and-paste, and my mother's recipe for chicken soup.

What I'm looking for are some real-life experiences. Who has done this and what have been your experiences? What works well and what doesn't work so hot?

Oh, one last requirement: The spreadsheets have to look "nice". Bold headings, frozen panes, formatted numeric columns with commas, appropriate column widths, all that stuff.

Joe DeShon Manager, Systems and Infrastructure Group CRM / Database Marketing Department Sprint PCS 6130 Sprint Parkway Mailstop: KSOPHJ0412-4B372 Overland Park KS 66251 Work: (913) 762-6172 PCS: (816) 210-0950 Fax: (913) 762-0817 email: jdesho01@sprintspectrum.com

--

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 unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.