Export a form via code?

[Guest]

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.

 

[Tom Ogilvy]

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

 

[Guest]

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.

 

[Rob van Gelder]

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

Rob

 

[Tom Ogilvy]

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

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

Rob

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.