Import and Export
 

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

Import and Export
 

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 wrote:
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

Import and Export
 

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?


"Jake Marx" wrote in message
...
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 wrote:
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

Import and Export
 

Hi Todd,

Todd Huttenstine wrote:
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.Impor t "c:\userform1.frm"

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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