Date:         Wed, 7 Jan 2004 15:58:05 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: HELP:::SAVE EXCEL FILE in HTML format to true .xls files
              inside              SAS????

Qiang:

If you can handle installing Perl and one or two perl modules, you might
take a look at
http://www.devenezia.com/downloads/sas/macros/?m=sas2xls
which uses
http://www.devenezia.com/downloads/sas/macros/?m=xmlib

The macro is for data only and thus no formatting ala ods html.  But it does
create a 'true' Excel 97 file.
Just a little tweaking and you can extend my 50 worksheet limit to any
number you want.

---
An improvement to your process would be to use DDE to open the 'linked'
excel file, and perform the Save As that 'inlines' all the links.  There
have been many (too many?) conference papers written for excel and dde.

--
Richard A. DeVenezia

"Ling, Qiang" <qal3@CDC.GOV> wrote in message
news:148E8334465C024399DD7B14E61D7D1550FD55@m-nchstp-2.nchstp.cdc.gov...
> Hi Guys,
>
> We had a SAS MACRO (using XML)to combine former generated EXCEL
> spreadsheets into one files. (The MACRO is posted below). But the
> problem is, After it creates your combined file, you MUST open it and
> Save As a true Excel file.  What the MACRO does is to create an HTML
> file with links to your other HTML pages that are spreadsheets.  So the
> resulting workbook is a set of links to these existing pages.  Once you
> Save As a .xls file, it will import the entire spreadsheet instead of
> just the link.  If you are to send this file to anyone, you have to
> remember this step.  Otherwise, they will get a workbook that's empty
> The original idea came from the SUGI paper by Chevelle Parker (look in
> the SUGI 28 CD directory).
>
> It works great with a little job loading. When I came to generate 110
> combined excel files with each one has 3 spreatsheets, it's a lot of
> work to open and save the files. Could any SAS expert modify my code
> (enclosed below) to save the final EXCEL files as a TRUE excel file
> instead of HTML file with links to individual spreadsheets?
>
> Thanks a lot!
>
snip