Macro form to Text - MSWord help

gi37ng · 09-21-2009, 09:11 AM

I have a macro form on MSWord(2003) and i want to fill it in and have it as text, say at the bottom of the page, so i can copy and paste it. Is this possible, if so, how do i go about it?
Thanks in advance.

**macropod** · 09-22-2009, 01:29 AM

Hi gi37ng,

Is this a userform, or a 'form' document using formfields? If you've got the text on a userform, why do you need to put it on the page before copying & pasting? Surely you can use the userform to insert the text wherever you want, without the need for copying & pasting. The same applies to text in formfields.

gi37ng · 09-22-2009, 05:21 AM

Thanks for your reply,

It's a 'form' document using formfields.
Basically i need the user to fill in this form and then i need to transfer the information entered/options selected into a webapp. Copying the whole form obviously doesnt work and its time consuming having to copy and paste each part. However, i still need user to use the form. Back when we didnt ask them to fill it in, information was missed out and there was a lot of back and forth to just get all this information. Does this make sense?

**macropod** · 09-22-2009, 05:59 AM

Hi gi37ng,

You can do all that without using a form. You can use formfields instead, each with an attached 'on exit' macro to validate the entry - much the same as you might be doing now via the form. That way, there's nothing to copy.

Nevertheless, what you can do with a userform is to have its contents populate a bookmark located wherever you need it in the document. If you prefer, each field on the form can populate a different bookmark. To populate a bookmark, you could use code like:

Code:

Sub UpdateBookmark (BmkNm as string, NewTxt as string)
Dim BmkRng as Range
With ActiveDocument
  Set BmkRng =.Bookmarks(BmkNm).Range
  BmkRng.Text = NewTxt
  .Bookmarks.Add BmkNm, BmkRng
End With
Set BmkRng = Nothing
End Sub

where the calling routine passes both the bookmark's name (BmkNm) and content (NewTxt) as parameters.

gi37ng · 09-22-2009, 06:21 AM

I'll try that. Cheers!

gi37ng · 09-22-2009, 08:36 AM

No luck.
Any idea on how to get it at text to copy and paste manually into the webapp?

**macropod** · 09-22-2009, 04:37 PM

Hi gi37ng,

It's difficult to help when your response is "No luck". Perhaps you could share a little more detail on what the problem is.

09-21-2009, 09:11 AM	#1 (permalink)
gi37ng Registered User Join Date: Sep 2009 Location: Channel Is Posts: 12 OS: Win XP	Macro form to Text - MSWord help I have a macro form on MSWord(2003) and i want to fill it in and have it as text, say at the bottom of the page, so i can copy and paste it. Is this possible, if so, how do i go about it? Thanks in advance.

09-22-2009, 01:29 AM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 561 OS: Vista	Re: Macro form to Text - MSWord help Hi gi37ng, Is this a userform, or a 'form' document using formfields? If you've got the text on a userform, why do you need to put it on the page before copying & pasting? Surely you can use the userform to insert the text wherever you want, without the need for copying & pasting. The same applies to text in formfields. __________________ Cheers macropod (MS MVP -Word)

09-22-2009, 05:21 AM	#3 (permalink)
gi37ng Registered User Join Date: Sep 2009 Location: Channel Is Posts: 12 OS: Win XP	Re: Macro form to Text - MSWord help Thanks for your reply, It's a 'form' document using formfields. Basically i need the user to fill in this form and then i need to transfer the information entered/options selected into a webapp. Copying the whole form obviously doesnt work and its time consuming having to copy and paste each part. However, i still need user to use the form. Back when we didnt ask them to fill it in, information was missed out and there was a lot of back and forth to just get all this information. Does this make sense?

09-22-2009, 05:59 AM	#4 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 561 OS: Vista	Re: Macro form to Text - MSWord help Hi gi37ng, You can do all that without using a form. You can use formfields instead, each with an attached 'on exit' macro to validate the entry - much the same as you might be doing now via the form. That way, there's nothing to copy. Nevertheless, what you can do with a userform is to have its contents populate a bookmark located wherever you need it in the document. If you prefer, each field on the form can populate a different bookmark. To populate a bookmark, you could use code like: Code: Sub UpdateBookmark (BmkNm as string, NewTxt as string) Dim BmkRng as Range With ActiveDocument Set BmkRng =.Bookmarks(BmkNm).Range BmkRng.Text = NewTxt .Bookmarks.Add BmkNm, BmkRng End With Set BmkRng = Nothing End Sub where the calling routine passes both the bookmark's name (BmkNm) and content (NewTxt) as parameters. __________________ Cheers macropod (MS MVP -Word)

09-22-2009, 06:21 AM	#5 (permalink)
gi37ng Registered User Join Date: Sep 2009 Location: Channel Is Posts: 12 OS: Win XP	Re: Macro form to Text - MSWord help I'll try that. Cheers!

09-22-2009, 08:36 AM	#6 (permalink)
gi37ng Registered User Join Date: Sep 2009 Location: Channel Is Posts: 12 OS: Win XP	Re: Macro form to Text - MSWord help No luck. Any idea on how to get it at text to copy and paste manually into the webapp?

09-22-2009, 04:37 PM	#7 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 561 OS: Vista	Re: Macro form to Text - MSWord help Hi gi37ng, It's difficult to help when your response is "No luck". Perhaps you could share a little more detail on what the problem is. __________________ Cheers macropod (MS MVP -Word)