Is it possible to write a macro that will import an existing form?

Thanks for all your help!
-Chad

Import a userform from a file? Su

ActiveWorkbook.VBProject.VBComponents.Import "c:\UserForm1.frm"

--
Jim
"Chad" wrote in message
...
| Is it possible to write a macro that will import an existing form?
|
| Thanks for all your help!
| -Chad

That's perfect! Thank you very much!!!

-Chad

"Jim Rech" wrote:

Import a userform from a file? Su

ActiveWorkbook.VBProject.VBComponents.Import "c:\UserForm1.frm"

--
Jim
"Chad" wrote in message
...
| Is it possible to write a macro that will import an existing form?
|
| Thanks for all your help!
| -Chad

hi,
if you are just import 1 form it might be better to do it manually.
open the file that has the form in it.
open the vb editor (alt + F11)
in the project window(far left), expand the project(filename) and right
click the form
click export. it will export as a .frm file.
you may wish to export to a floppy disk which can be transfer to other pc's
easily.
close the file
open the file you want the form in.
open the vb editor
in the project window, expand the project
right click the project name and click import
from the dialog box, select the form that you just exported and click ok
done

regards
FSt1

"Chad" wrote:

Is it possible to write a macro that will import an existing form?

Thanks for all your help!
-Chad

Thanks for the response. However, I am capable of doing it manually, but I
would like to do it within a macro. Is it possible to write this within a
macro?
Thanks,
Chad

"FSt1" wrote:

hi,
if you are just import 1 form it might be better to do it manually.
open the file that has the form in it.
open the vb editor (alt + F11)
in the project window(far left), expand the project(filename) and right
click the form
click export. it will export as a .frm file.
you may wish to export to a floppy disk which can be transfer to other pc's
easily.
close the file
open the file you want the form in.
open the vb editor
in the project window, expand the project
right click the project name and click import
from the dialog box, select the form that you just exported and click ok
done

regards
FSt1

"Chad" wrote:

Is it possible to write a macro that will import an existing form?

Thanks for all your help!
-Chad