Prev: Macro Needed
Next: Fill combo from word table
From: djl0525 on 8 May 2010 02:28
I found this spreadsheet by John Walkenbach (Excel Guru) that has code
I'd like to use in Word.

http://spreadsheetpage.com/index.php/tip/mail_merge_without_word

1. John's Excel file has a help button that displays a userform.
2. The userform displays directions to guide the user on how to do
something in Excel.
3. The directions (text) in the userform is stored in one of the
sheets in the workbook.

Those are the elements I care about. A userform with text that is
editable.

The procedure in John's Excel file talks you through doing a mail
merge in Excel without using Microsoft word, but I don't care about
that. What I want is a userform in Word that displays text (stored in
Word) that I can easily edit. If the help text needs to be in a
separate Word document, that's fine.

1. A help button is easy.
2. A userform is easy.
3. Where to store the editable text and how to get it in the userform
- that's the challenge!!

If anyone is interested in taking on this challenge, please contact
me. Thank you in advance for your consideration.

--DJ
From: Doug Robbins - Word MVP on 8 May 2010 03:40
Use the code similar to the following in the initialize event of the
userform

Dim source As Document
Dim strFormText As String
Set source = Documents.Open("C:\test\formtext.doc")
strFormText = source.Range.Text
TextBox1.Text = strFormText
source.Close wdDoNotSaveChanges
Set source = Nothing

You will need to set the Multiline attribute of TextBox1 to True and
probably the ScrollBars attribute to 2 - fmScrollBarsVertical

--
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, originally posted via msnews.microsoft.com

"djl0525" <djl0525(a)gmail.com> wrote in message
news:7fbd2dd5-7d46-4aa9-a02e-df78faaf58d3(a)h9g2000yqm.googlegroups.com...
> I found this spreadsheet by John Walkenbach (Excel Guru) that has code
> I'd like to use in Word.
>
> http://spreadsheetpage.com/index.php/tip/mail_merge_without_word
>
> 1. John's Excel file has a help button that displays a userform.
> 2. The userform displays directions to guide the user on how to do
> something in Excel.
> 3. The directions (text) in the userform is stored in one of the
> sheets in the workbook.
>
> Those are the elements I care about. A userform with text that is
> editable.
>
> The procedure in John's Excel file talks you through doing a mail
> merge in Excel without using Microsoft word, but I don't care about
> that. What I want is a userform in Word that displays text (stored in
> Word) that I can easily edit. If the help text needs to be in a
> separate Word document, that's fine.
>
> 1. A help button is easy.
> 2. A userform is easy.
> 3. Where to store the editable text and how to get it in the userform
> - that's the challenge!!
>
> If anyone is interested in taking on this challenge, please contact
> me. Thank you in advance for your consideration.
>
> --DJ

From: djl0525 on 9 May 2010 22:30
Doug, did you get my message? I'd like to know your rates.

--DJ

On May 8, 3:40 am, "Doug Robbins - Word MVP" <d...(a)REMOVECAPSmvps.org>
wrote:
> Use the code similar to the following in the initialize event of the
> userform
>
> Dim source As Document
> Dim strFormText As String
> Set source = Documents.Open("C:\test\formtext.doc")
> strFormText = source.Range.Text
> TextBox1.Text = strFormText
> source.Close wdDoNotSaveChanges
> Set source = Nothing
>
> You will need to set the Multiline attribute of TextBox1 to True and
> probably the ScrollBars attribute to 2 - fmScrollBarsVertical
>
> --
> 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, originally posted via msnews.microsoft.com
>
> "djl0525" <djl0...(a)gmail.com> wrote in message
>
> news:7fbd2dd5-7d46-4aa9-a02e-df78faaf58d3(a)h9g2000yqm.googlegroups.com...
>
> > I found this spreadsheet by John Walkenbach (Excel Guru) that has code
> > I'd like to use in Word.
>
> >http://spreadsheetpage.com/index.php/tip/mail_merge_without_word
>
> > 1. John's Excel file has a help button that displays a userform.
> > 2. The userform displays directions to guide the user on how to do
> > something in Excel.
> > 3. The directions (text) in the userform is stored in one of the
> > sheets in the workbook.
>
> > Those are the elements I care about.  A userform with text that is
> > editable.
>
> > The procedure in John's Excel file talks you through doing a mail
> > merge in Excel without using Microsoft word, but I don't care about
> > that. What I want is a userform in Word that displays text (stored in
> > Word) that I can easily edit. If the help text needs to be in a
> > separate Word document, that's fine.
>
> > 1. A help button is easy.
> > 2. A userform is easy.
> > 3. Where to store the editable text and how to get it in the userform
> > - that's the challenge!!
>
> > If anyone is interested in taking on this challenge, please contact
> > me.  Thank you in advance for your consideration.
>
> > --DJ

 | 
Pages: 1
Prev: Macro Needed
Next: Fill combo from word table