RTF UserForm Run-time error question

[webeinky]

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.

 

[Doug Robbins - Word MVP]

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]

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

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.

 

[Doug Robbins - Word MVP]

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.

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

 

[webeinky]

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.