Hi

I want to import a userfom and module in an .xlt with VBA. Then I want
to save my .xlt to a temp.xls. and open temp.xls

When temp.xls opens it must run the macro from the module i've
imported. The first step of the macro is to show a useform.

Can anyone say me how to dow that?

In Word i'm doing the same. In a .dot file I've got a AutoNew() Marco
that imports me a module and an userform. Then it's saves the .dot to
temp.doc. After that is opens temp.doc. Because temp.com now has the
imported module and userform I can use them. The module has an
AuotOpen() event witch show the userform.

Raymond


---
Message posted from http://www.ExcelForum.com/