Re: Automate a form textbox

From: John Viall (JohnViall_at_discussions.microsoft.com)
Date: 11/28/04 

Date: Sun, 28 Nov 2004 12:07:08 -0800

Thanks, it works great.

Is there a good reference book that shows the objects, properties and
methods for the Office suite?

Thanks again for your help.

"Jean-Guy Marcil" wrote:

> John Viall was telling us:
> John Viall nous racontait que :
>
> > Thanks, the top part of your reply worked, however the second part
> > regarding opening an Excel spread*** gave me an error, on the first
> > line.
> >
> > Just for troubleshooting, and to examine the code, I put it into a
> > Subroutine called OpenExcel.
> >
> > It highlights the following:
> > MyXL As Excel.Application
> >
> > And gives the error, User-defined type not defined.
>
> Have you set a reference to the Excel Library?
> In the VBA editor, Tools > References... > Check "Microsoft Excel..."
>
> > While at it, is there a way to determine the path of the original Word
> > Template, and use that to find the Work***?
>
> You mean:
>
> Dim MyPath as String
> MyPath = ActiveDocument.AttachedTemplate.Path
>
> ?
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
>
>
>