Greeting,

I have a UserForm in one workbook that I need to open from a
CommandButton in another workbook. I don't know the syntax to put in
that CommandButton's code to accomplish this.

Anyone know how to do this?

Any help would be greatly appreciated.

-Minitman

Application.Run "'fileName.xls'!ShowForm"

Where ShowForm is a routine in a normal module in the other workbook that
show's the form.

Depending on fileName.xls you might need to embrace it with apostrophes, no
harm to include them

Regards,
Peter T

"Minitman" wrote in message
...
Greeting,

I have a UserForm in one workbook that I need to open from a
CommandButton in another workbook. I don't know the syntax to put in
that CommandButton's code to accomplish this.

Anyone know how to do this?

Any help would be greatly appreciated.

-Minitman

Hey Peter,

That works great!

Thank you very much.

-Minitman




On Wed, 10 Sep 2008 20:21:17 +0100, "Peter T" <peter_t@discussions
wrote:

Application.Run "'fileName.xls'!ShowForm"

Where ShowForm is a routine in a normal module in the other workbook that
show's the form.

Depending on fileName.xls you might need to embrace it with apostrophes, no
harm to include them

Regards,
Peter T

"Minitman" wrote in message
.. .
Greeting,

I have a UserForm in one workbook that I need to open from a
CommandButton in another workbook. I don't know the syntax to put in
that CommandButton's code to accomplish this.

Anyone know how to do this?

Any help would be greatly appreciated.

-Minitman