Import and Export

[Todd Huttenstine]

How do you export userforms from a project using VBA code?

Also how do you import userforms from a project using VBA code?


Thanks
Todd Huttenstine

 

[Jake Marx]

Hi Todd,

Did you check out Chip's page on programming the VBE?

http://www.cpearson.com/excel/vbe.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Todd Huttenstine]

Yes with some of that code I was able to export all components, but the
only problem is, it exports userforms as .frm and .frx and I cant import
them back into a project.

If there is a way to import userforms (.frm and .frx) into a project, how?

Hi Todd,

Did you check out Chip's page on programming the VBE?

http://www.cpearson.com/excel/vbe.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

How do you export userforms from a project using VBA code?

Also how do you import userforms from a project using VBA code?


Thanks
Todd Huttenstine

 

[Jake Marx]

Hi Todd,

Yes with some of that code I was able to export all components, but
the only problem is, it exports userforms as .frm and .frx and I cant
import them back into a project.

If there is a way to import userforms (.frm and .frx) into a project,
how?

I think this will work (worked for me):

Application.VBE.ActiveVBProject.VBComponents.Import "c:\userform1.frm"

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]