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
Content-Type: text/plain; charset="iso-8859-1"
Take a look at my paper on Generating 10,000 Excel spreadsheets on
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.
Savian "Bridging SAS and Microsoft Technologies"
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Reeza
Sent: Monday, April 23, 2007 1:09 PM
Subject: Excel Help
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.