Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
webeinky webeinky is offline
external usenet poster
 
Posts: 6
Default RTF UserForm Run-time error question

Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we must
use RTF.

I have recently been assigned a project to create a large merge document. I
have created a UserForm to capture and use some data that is not available in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen (set up
connected to the document instead of connected to the Normal.doc) when I
try to merge this document at another PC I get a Run-time Error '91. And the
UserForm does not open. (If I merge it using the PC the original doc was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm. And at
another PC again I get the Run-time Error '91. But I can hit "End" and then
run the Macro which works.

Is there any way to program a RTF document to automatically open a UserForm
without getting the Run-time Error no matter who is merging the document?

Thank you in advance for your help.

--
Nancy

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default RTF UserForm Run-time error question

You could use an autoopen() macro in a template that is stored in the Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge document.
I
have created a UserForm to capture and use some data that is not available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen (set
up
connected to the document instead of connected to the Normal.doc) when I
try to merge this document at another PC I get a Run-time Error '91. And
the
UserForm does not open. (If I merge it using the PC the original doc was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm. And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the document?

Thank you in advance for your help.

--
Nancy


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
webeinky webeinky is offline
external usenet poster
 
Posts: 6
Default RTF UserForm Run-time error question

Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge document.
I
have created a UserForm to capture and use some data that is not available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen (set
up
connected to the document instead of connected to the Normal.doc) when I
try to merge this document at another PC I get a Run-time Error '91. And
the
UserForm does not open. (If I merge it using the PC the original doc was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm. And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the document?

Thank you in advance for your help.

--
Nancy


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default RTF UserForm Run-time error question

You need to create a new template and then select that template in the
Macros in: control and after creating the macro, you need to save the
template in the Word Startup Folder.

I am not sure why you are using RTF documents. It sounds like you should
be creating a template that contains an AutoNew macro that will display the
userform when the user creates a new document from the template.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All
active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the
Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge
document.
I
have created a UserForm to capture and use some data that is not
available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen
(set
up
connected to the document instead of connected to the Normal.doc)
when I
try to merge this document at another PC I get a Run-time Error '91.
And
the
UserForm does not open. (If I merge it using the PC the original doc
was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm.
And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the
document?

Thank you in advance for your help.

--
Nancy



  #5   Report Post  
Posted to microsoft.public.word.docmanagement
webeinky webeinky is offline
external usenet poster
 
Posts: 6
Default RTF UserForm Run-time error question

Hi Doug,

I'm sorry it has taken me so long to reply to your post. I do appreciate
your speedy replies. I got distracted with another project.

I'm not sure we are talking about the same type of UserForm. The UserForm I
am refering to I created in Visual Basic.

It sounds like your reply is setting up another document Template as the
"UserForm" which would open anytime I open a Word Doc by using the AutoNew
macro - not just the one doc I am working with?

I have programmed a "work around". I still get the Run-time error but when
we click on "End" it opens up the document and merges the data just fine. I
then start the macro I set up using Ctrl-U and that opens the UserForm I
created for additional input.

I would prefer not to have to be messing with RTF docs. But it is the
format the Database Software (it is a whole program) is forcing me to use for
merging data within their program.

Thanks again for all your help.
--
Nancy


"Doug Robbins - Word MVP" wrote:

You need to create a new template and then select that template in the
Macros in: control and after creating the macro, you need to save the
template in the Word Startup Folder.

I am not sure why you are using RTF documents. It sounds like you should
be creating a template that contains an AutoNew macro that will display the
userform when the user creates a new document from the template.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All
active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the
Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge
document.
I
have created a UserForm to capture and use some data that is not
available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen
(set
up
connected to the document instead of connected to the Normal.doc)
when I
try to merge this document at another PC I get a Run-time Error '91.
And
the
UserForm does not open. (If I merge it using the PC the original doc
was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm.
And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the
document?

Thank you in advance for your help.

--
Nancy





  #6   Report Post  
Posted to microsoft.public.word.docmanagement
webeinky webeinky is offline
external usenet poster
 
Posts: 6
Default RTF UserForm Run-time error question

Hi Doug,

I'm sorry it has taken me so long to reply to your post. I do appreciate
your speedy replies. I got distracted with another project.

I'm not sure we are talking about the same type of UserForm. The UserForm I
am refering to I created in Visual Basic.

It sounds like your reply is setting up another document Template as the
"UserForm" which would open anytime I open a Word Doc by using the AutoNew
macro - not just the one doc I am working with?

I have programmed a "work around". I still get the Run-time error but when
we click on "End" it opens up the document and merges the data just fine. I
then start the macro I set up using Ctrl-U and that opens the UserForm I
created for additional input.

I would prefer not to have to be messing with RTF docs. But it is the
format the Database Software (it is a whole program) is forcing me to use for
merging data within their program.

Thanks again for all your help.
--
Nancy


"Doug Robbins - Word MVP" wrote:

You need to create a new template and then select that template in the
Macros in: control and after creating the macro, you need to save the
template in the Word Startup Folder.

I am not sure why you are using RTF documents. It sounds like you should
be creating a template that contains an AutoNew macro that will display the
userform when the user creates a new document from the template.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All
active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the
Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge
document.
I
have created a UserForm to capture and use some data that is not
available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen
(set
up
connected to the document instead of connected to the Normal.doc)
when I
try to merge this document at another PC I get a Run-time Error '91.
And
the
UserForm does not open. (If I merge it using the PC the original doc
was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm.
And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the
document?

Thank you in advance for your help.

--
Nancy



  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default RTF UserForm Run-time error question

You need to create a new template and then select that template in the
Macros in: control and after creating the macro, you need to save the
template in the Word Startup Folder.

I am not sure why you are using RTF documents. It sounds like you should
be creating a template that contains an AutoNew macro that will display the
userform when the user creates a new document from the template.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All
active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the
Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services
on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge
document.
I
have created a UserForm to capture and use some data that is not
available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen
(set
up
connected to the document instead of connected to the Normal.doc)
when I
try to merge this document at another PC I get a Run-time Error '91.
And
the
UserForm does not open. (If I merge it using the PC the original doc
was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm.
And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the
document?

Thank you in advance for your help.

--
Nancy



  #8   Report Post  
Posted to microsoft.public.word.docmanagement
webeinky webeinky is offline
external usenet poster
 
Posts: 6
Default RTF UserForm Run-time error question

Doug,

Thank you for your speedy reply.

I am a bit embarassed, I'm not sure how to do what you suggest. When I
create the autoopen() macro for the box "Macros in:" do I us the "All active
templates and documents" selection?

Does your suggestion affect any of the other RTF merge documents I have
created? I only want this UserForm to open for this one document

--
Nancy


"Doug Robbins - Word MVP" wrote:

You could use an autoopen() macro in a template that is stored in the Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge document.
I
have created a UserForm to capture and use some data that is not available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen (set
up
connected to the document instead of connected to the Normal.doc) when I
try to merge this document at another PC I get a Run-time Error '91. And
the
UserForm does not open. (If I merge it using the PC the original doc was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm. And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the document?

Thank you in advance for your help.

--
Nancy


  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default RTF UserForm Run-time error question

You could use an autoopen() macro in a template that is stored in the Word
startup folder to display a userform that is in that template.

The userform would then be displayed when any document is opened.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"webeinky" wrote in message
...
Hello,

I hope someone can help me with an issue I am up against.

Our main software program uses RTF formatted documents to create merge
documents using the data from the program. We don't have an option, we
must
use RTF.

I have recently been assigned a project to create a large merge document.
I
have created a UserForm to capture and use some data that is not available
in
the software program.

I want this UserForm to open immediately. I find if I use AutoOpen (set
up
connected to the document instead of connected to the Normal.doc) when I
try to merge this document at another PC I get a Run-time Error '91. And
the
UserForm does not open. (If I merge it using the PC the original doc was
created on the UserForm opens immediately and without error)

I also tried creating a Macro to manually run to open the UserForm. And
at
another PC again I get the Run-time Error '91. But I can hit "End" and
then
run the Macro which works.

Is there any way to program a RTF document to automatically open a
UserForm
without getting the Run-time Error no matter who is merging the document?

Thank you in advance for your help.

--
Nancy


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm Question Owen Microsoft Word Help 6 February 22nd 09 05:39 AM
userform question Erik Witkop Microsoft Word Help 7 May 16th 08 01:03 AM
Userform question (selecting name will self complete fields) Darren Ingram Microsoft Word Help 1 April 23rd 08 12:46 PM
run time error 91 tonyd Microsoft Word Help 1 June 24th 06 07:46 AM
run time error 91 moose Microsoft Word Help 3 April 7th 05 11:05 PM


All times are GMT +1. The time now is 12:14 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"