Date: Tue, 10 Apr 2007 16:27:13 -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: Reading Document Properties from Word, PowerPoint,
and PDF Files
In-Reply-To: <B0D86A37DFFC644CBA38735A33E3FE3101ABA607@SXGM-402.fg.rbc.com>
Content-Type: text/plain; charset="iso-8859-1"
It is easy to pull this info using C#. Download the free Visual Studio
Express C# and have at it.
I wouldn't bother with VBA, DDE, or C++ unless you have to. If you need to
go to a non-SAS program, do it right IMO.
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
Droogendyk, Harry
Sent: Tuesday, April 10, 2007 4:22 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Reading Document Properties from Word, PowerPoint, and PDF
Files
Would DDE surface this info for you? Does Microsoft publish a decent
DDE reference? I couldn't find anything after a quick search, but there
must be something.
Here's a Visual C++ solution for the MS stuff:
http://www.kbalertz.com/Q186898/Compound.Document.Properties.Directly.as
px
Or, perhaps better to write some VBA to interact with the MS office
files and pull the info for you?
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Ed Heaton
Sent: 2007, April, 10 2:09 PM
To: Nathaniel.Wooding@dom.com; SAS-L@LISTSERV.UGA.EDU
Subject: RE: Reading Document Properties from Word, PowerPoint, and PDF
Files
Thanks much, Nat. I'll let you know how it goes (after the Forum, of
course).
Ed
Ed Heaton
RW-4541
#4818
-----Original Message-----
From: Nathaniel.Wooding@dom.com [mailto:Nathaniel.Wooding@dom.com]
Sent: Tuesday, April 10, 2007 2:04 PM
To: Ed Heaton
Subject: Re: Reading Document Properties from Word, PowerPoint, and PDF
Files
Ed
I'm assuming that you want to do this with bunches of files. I have a
method of reading pdf files using an executable bit of Ghostscript that
will convert the pdf to ascii which SAS can parse. The attached paper
described the process. This paper has gone through several generations
and I think that the copy below is the last.
Nat
(See attached file: EXTRACTING DATA FROM PDF FILES.doc)
Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Ed Heaton
<EdHeaton@WESTAT.
COM>
To
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
Discussion"
cc
<SAS-L@LISTSERV.U
GA.EDU>
Subject
Reading Document Properties from
Word, PowerPoint, and PDF Files
04/10/2007 01:06
PM
Please respond to
Ed Heaton
<EdHeaton@WESTAT.
COM>
> I need to read the title, author, subject, and keywords fields from MS
> Word, PowerPoint, and PDF files. Looking for help. I'm running SAS
> 9.1.3 and have SAS/ACCESS for OLE DB and ODBC licensed.
>
> Ed
>
> Edward Heaton, Senior Systems Analyst, Westat (An Employee-Owned
> Research Corporation), 1650 Research Boulevard, RW-4541, Rockville, MD
> 20850-3195
> Voice: (301) 610-4818 Fax: (301) 294-3879
> mailto:EdHeaton@Westat.com http://www.Westat.com
>
>
-----------------------------------------
CONFIDENTIALITY NOTICE: This electronic message contains information
which may be legally confidential and/or privileged and does not in any
case represent a firm ENERGY COMMODITY bid or offer relating thereto
which binds the sender without an additional express written
confirmation to that effect. The information is intended solely for the
individual or entity named above and access by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution, or use of the contents of this information is
prohibited and may be unlawful. If you have received this electronic
transmission in error, please reply immediately to the sender that you
have received the message in error, and delete it. Thank you.
_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it
contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or
otherwise) immediately.
Ce courrier électronique est confidentiel et protégé. L'expéditeur ne
renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements
qu'il contient par une personne autre que le (les) destinataire(s)
désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser
immédiatement, par retour de courrier électronique ou par un autre moyen.
