Date:         Tue, 15 Jul 2008 05:19:09 -0600
Reply-To:     Alan Churchill <savian001@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <savian001@GMAIL.COM>
Subject:      Re: tab names from a Excel file
Comments: To: d-dubs <m.denniswilliams@gmail.com>
In-Reply-To:  <05082e0a-8b16-4575-8700-3285c0081511@r66g2000hsg.googlegroups.com>
Content-Type: text/plain; charset="US-ASCII"

I created a utility for you to use that does this. You can either execute
from within SAS using the X command or run it standalone.

Usage:

FindTabs "c:\temp\MyTabData.txt" "c:\temp\test1.xls"  "c:\temp\test2.xls"
.... and on and on.


Find it here:

http://cid-8bca55fbca813d37.skydrive.live.com/self.aspx/Public/Savian/FindTa
bs.exe?#comments

Alan

Alan Churchill
Savian
www.savian.net

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of d-dubs
Sent: Monday, July 14, 2008 3:28 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: tab names from a Excel file

Hi Arthur,
Your method works only when the excel file is open. But I have like 20
different excel files with around 15 tabs each.
I need a dynamic way to read in all the tab names from the specific
excel files.