Date:         Mon, 23 Apr 2007 20:20:19 -0600
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      Re: Excel Help
Comments: To: Reeza <fkhurshed@HOTMAIL.COM>
In-Reply-To:  <1177355319.831862.190070@b75g2000hsg.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Reeza,

Take a look at my paper on Generating 10,000 Excel spreadsheets on
http://www.sasCommunity.org

This does not directly address your question but the method used is the best
way to pull the information from spreadsheets. The 3rd party tool used will
set you back $400 so be prepared but it can read it all in.

Basically, I think you need to view this as an "out-of-Excel" process. Look
at VSTO, VBA, Aspose.Cells, or some other 3rd party mechanism to do it.

Alan

Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Reeza
Sent: Monday, April 23, 2007 1:09 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Excel Help

Hi All,

I have a bunch of clinical trials with messy data, but a Excel Summary
Sheet to summarize/format the data.

I would like to copy this excel summary sheet (with formula's) to many
excel workbooks. Is there an efficient way to do this?
I tried to export it using a SAS macro, but what I get are the
original values not formula's.

Thanks,
Reeza