Date:         Wed, 2 Feb 2000 09:56:52 +0100
Reply-To:     Louis Broekhuijsen <louis.broekhuijsen@CMG.NL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Louis Broekhuijsen <louis.broekhuijsen@CMG.NL>
Subject:      Re: Capturing information from Excel via DDE
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

I use OLE.

Louis Broekhuijsen

-----Original Message-----
From:   chris@TELESPAN.DEMON.CO.UK [mailto:chris@TELESPAN.DEMON.CO.UK]
Sent:   Friday, January 28, 2000 12:28 PM
To:     SAS-L@AKH-WIEN.AC.AT
Subject:        Capturing information from Excel via DDE

Does anyone know of a method of capturing the following information from
a Excel97 workbook?

1. Sheet names
2. Number of Active Rows in sheet.
3. Number of Active Columns in sheet.

There appears to be an Excel4 macro call to ascertain all this
information but it is NOT implemented in Excel97. I assume therefore
that one will need to capture this information via a WinAPI call using
MODULEN. Any information about the methodology for this will be very
gratefully received.

Thanks inanticipation


Chris Jones


Sent via Deja.com http://www.deja.com/
Before you buy.