Export a form via code?
 

I have a form with MANY controls. I am changing some of the controls'
properties in my program. Is there any I can export the form with the
changes properties?

Could I export it via code while the properties are changed?

Thanks.

Export a form via code?
 

The best test, specific to your situation, is to do it and examine the
results.

--
Regards,
Tom Ogilvy

wrote in message
...
I have a form with MANY controls. I am changing some of the controls'
properties in my program. Is there any I can export the form with the
changes properties?

Could I export it via code while the properties are changed?

Thanks.

Export a form via code?
 

Thanks for the reply.

I tried to export it via code but it didn't work, probably because I was
guessing at the code to export it. I din't see anything helpful in the VBA
help. I tired FormName.Export "FileName" and a few other things that did
not work.

On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy" wrote:

The best test, specific to your situation, is to do it and examine the
results.

Export a form via code?
 

ThisWorkbook.VBProject.VBComponents("UserForm1").E xport "C:\T\UserForm1.frm"

Rob


wrote in message
...
Thanks for the reply.

I tried to export it via code but it didn't work, probably because I was
guessing at the code to export it. I din't see anything helpful in the
VBA
help. I tired FormName.Export "FileName" and a few other things that did
not work.

On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy" wrote:

The best test, specific to your situation, is to do it and examine the
results.

Export a form via code?
 

Just to add, create a reference to the Microsoft Visual Basic Extensibility
Library. Then in the VBE, use the object browser to search for Export in
the VBIDE library. Highlight the export command under VBComponents and hit
F1 to get help (or click the help icon in the object browser).

--
Regards,
Tom Ogilvy


Rob van Gelder wrote in message
...
ThisWorkbook.VBProject.VBComponents("UserForm1").E xport
"C:\T\UserForm1.frm"

Rob


wrote in message
...
Thanks for the reply.

I tried to export it via code but it didn't work, probably because I was
guessing at the code to export it. I din't see anything helpful in the
VBA
help. I tired FormName.Export "FileName" and a few other things that
did
not work.

On Sun, 25 Jan 2004 22:06:19 -0500, "Tom Ogilvy"
wrote:

The best test, specific to your situation, is to do it and examine the
results.