Prev: Removing disabled items in word 2007 (VBA)
Next: Catching the New Page event in VBA
From: bryan on 16 Jul 2008 08:02
If I am in a form document and entering data in formfields, is it possible to
extract info from a saved document to populate a few of the formfields?
I know the file path of the saved document.
Ideas....

Thanks,
Bryan
From: macropod on 16 Jul 2008 08:37
Hi Bryan,

Is there a reason the info has to go into a formfield? Why, for example, couldn't you use a standard INCLUDETEXT field (which you
could populate with a variable (eg a filename or a bookmark) from a formfield, if need be)?

--
Cheers
macropod
[MVP - Microsoft Word]


"bryan" <bryan(a)discussions.microsoft.com> wrote in message news:E54650F5-A4D2-449C-BAF0-334DE68A713A(a)microsoft.com...
> If I am in a form document and entering data in formfields, is it possible to
> extract info from a saved document to populate a few of the formfields?
> I know the file path of the saved document.
> Ideas....
>
> Thanks,
> Bryan

From: bryan on 16 Jul 2008 11:04
When I open a protected document (an Issue WS) I am populating some of the
form fields from our host system.
What the users would like is to also extract some info from the Quote WS
rather than having to type it in again. This can only populate if the Quote
Ws is found.

So when I open the Issue WS, I already know where the Quite WS is stored so
I got the file path, I just need to know how to open the document and then
extract info from form fields

Thank,
Bryan



"macropod" wrote:

> Hi Bryan,
>
> Is there a reason the info has to go into a formfield? Why, for example, couldn't you use a standard INCLUDETEXT field (which you
> could populate with a variable (eg a filename or a bookmark) from a formfield, if need be)?
>
> --
> Cheers
> macropod
> [MVP - Microsoft Word]
>
>
> "bryan" <bryan(a)discussions.microsoft.com> wrote in message news:E54650F5-A4D2-449C-BAF0-334DE68A713A(a)microsoft.com...
> > If I am in a form document and entering data in formfields, is it possible to
> > extract info from a saved document to populate a few of the formfields?
> > I know the file path of the saved document.
> > Ideas....
> >
> > Thanks,
> > Bryan
>
>
From: Doug Robbins - Word MVP on 16 Jul 2008 15:39
Something like

Dim Source as Document, Target as Document
Set Target = ActiveDocument 'The document into which you want to insert the
data
Set Source = Documents.Open("Drive\Path\Filename") 'The document that
contains the data that you want to use
With Target
.FormFields("nameofformfieldintowhichyouwanttoinsertthedata").Result = _
Source.FormFields("nameofformfieldthatcontainsthedatathatyouwant").Result
'repeat as necessary for each item of required data
'Do other things with Target
.SaveAs
End With
Source.Close wdDoNotSaveChanges
Set Source = Nothing


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"bryan" <bryan(a)discussions.microsoft.com> wrote in message
news:C49599CC-7054-4F3C-A8DE-1B44A3D0A869(a)microsoft.com...
> When I open a protected document (an Issue WS) I am populating some of the
> form fields from our host system.
> What the users would like is to also extract some info from the Quote WS
> rather than having to type it in again. This can only populate if the
> Quote
> Ws is found.
>
> So when I open the Issue WS, I already know where the Quite WS is stored
> so
> I got the file path, I just need to know how to open the document and then
> extract info from form fields
>
> Thank,
> Bryan
>
>
>
> "macropod" wrote:
>
>> Hi Bryan,
>>
>> Is there a reason the info has to go into a formfield? Why, for example,
>> couldn't you use a standard INCLUDETEXT field (which you
>> could populate with a variable (eg a filename or a bookmark) from a
>> formfield, if need be)?
>>
>> --
>> Cheers
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "bryan" <bryan(a)discussions.microsoft.com> wrote in message
>> news:E54650F5-A4D2-449C-BAF0-334DE68A713A(a)microsoft.com...
>> > If I am in a form document and entering data in formfields, is it
>> > possible to
>> > extract info from a saved document to populate a few of the formfields?
>> > I know the file path of the saved document.
>> > Ideas....
>> >
>> > Thanks,
>> > Bryan
>>
>>


From: bryan on 20 Jul 2008 15:16
Thanks much.

Bryan

"bryan" wrote:

> When I open a protected document (an Issue WS) I am populating some of the
> form fields from our host system.
> What the users would like is to also extract some info from the Quote WS
> rather than having to type it in again. This can only populate if the Quote
> Ws is found.
>
> So when I open the Issue WS, I already know where the Quite WS is stored so
> I got the file path, I just need to know how to open the document and then
> extract info from form fields
>
> Thank,
> Bryan
>
>
>
> "macropod" wrote:
>
> > Hi Bryan,
> >
> > Is there a reason the info has to go into a formfield? Why, for example, couldn't you use a standard INCLUDETEXT field (which you
> > could populate with a variable (eg a filename or a bookmark) from a formfield, if need be)?
> >
> > --
> > Cheers
> > macropod
> > [MVP - Microsoft Word]
> >
> >
> > "bryan" <bryan(a)discussions.microsoft.com> wrote in message news:E54650F5-A4D2-449C-BAF0-334DE68A713A(a)microsoft.com...
> > > If I am in a form document and entering data in formfields, is it possible to
> > > extract info from a saved document to populate a few of the formfields?
> > > I know the file path of the saved document.
> > > Ideas....
> > >
> > > Thanks,
> > > Bryan
> >
> >
 | 
Pages: 1
Prev: Removing disabled items in word 2007 (VBA)
Next: Catching the New Page event in VBA