Date:         Fri, 18 Apr 2008 15:46:22 -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: Reading MS Word ".doc" files into SAS
Comments: To: Jake Bee <johbee@gmail.com>
In-Reply-To:  <ed52c9100804181442g4492647che30b8f4c735cfc4c@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Macros throw warning errors and they use VBA. It is better, IMO, to do the
work outside of Word and simply write to the Word (or Excel) object model.
There are loads of examples on the web for how to make it happen.

Alan

Alan Churchill
Savian
www.savian.net



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jake
Bee
Sent: Friday, April 18, 2008 3:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Reading MS Word ".doc" files into SAS

Yes, this would be great to use if SAS can run an MS macro!

On Fri, Apr 18, 2008 at 4:06 PM, Mary <mlhoward@avalon.net> wrote:

> Can SAS run a macro on a Word document?  Or an Excel document?  If so,
> how?  Yes, this user could run a macro which saved the document as a text
> document (or to an Excel file, if appropriate), and then import the text
> document that was saved.
>
> I'd be interested as well- I have output which I export to Excel and then
> run a macro on Excel to format the sheet; it would be nice to add that to
my
> SAS code so I didn't have to run it individually from Excel.
>
> -Mary
>   ----- Original Message -----
>  From: Nat Wooding
>  To: SAS-L@LISTSERV.UGA.EDU
>  Sent: Friday, April 18, 2008 2:15 PM
>  Subject: Re: Reading MS Word ".doc" files into SAS
>
>
>   I first thought of DDE but I'm not sure that it will work here since, as
>  far as I remember, DDE only reads tabular data from word.
>
>  Since the desire is to read some part of the doc, I wonder if you could
> use
>  SAS to open the doc using the word macros and then save it to a text file
>  which could be parsed. This would be an alternative   to using a
> downloaded
>  executable.
>
>  Nat Wooding
>  Environmental Specialist III
>  Dominion, Environmental Biology
>  4111 Castlewood Rd
>  Richmond, VA 23234
>  Phone:804-271-5313, Fax: 804-271-2977
>