Date: Tue, 11 May 2010 08:53:42 -0400
Reply-To: Jack Clark <jclark@HILLTOP.UMBC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Clark <jclark@HILLTOP.UMBC.EDU>
Subject: Autosize Excel Columns from SAS
Content-Type: text/plain; charset="us-ascii"
I am using SAS (v9.1 on Windows) to write a series of datasets to a
Microsoft Excel workbook with PROC EXPORT. Each dataset goes to a
separate worksheet and currently there are 24. This is working fine.
The thing I don't like is that my Excel file does not size the columns
to fully display the data. I don't want to go in manually and size the
columns. Years ago I know I wrote a VBA macro to do this, which I
called from SAS with DDE.
I am wondering if there is a better way to issue commands from SAS that
will open the Excel file and autosize the columns in ALL worksheets in
the workbook? Or is VBA macro and DDE the preferred method? Any
suggestions are appreciated.
Senior Research Analyst
University of Maryland, Baltimore County
Sondheim Hall, 3rd Floor
1000 Hilltop Circle
Baltimore, MD 21250
Please consider the environment before printing this email and/or any attachments.
Confidentiality Notice: This e-mail may contain information that is legally privileged and that is intended only for the use of the addressee(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying of this e-mail, distribution, or action taken in reliance on the contents of this e-mail and/or documents attributed to this e-mail is strictly prohibited. If you have received this information in error, please notify the sender immediately by phone and delete this entire e-mail. Thank you.