Importing .frm Files

[AB]

I can't seem to import (through the File > Get External Data > Import menu)
an .frm file of a form I'm using in an Excel app. Is there some way to
import the .frm file that I don't know about?

 

[Tom Ellison]

Dear AB:

I strongly suggest that, to get the best expert assistance on your question,
you look for a newsgroup whose topic is Excel.

This newsgroup is for Access, a different Microsoft Office product. While
many of us do know a bit about Excel, it isn't our advertised specialty in
this newsgroup.

Best of luck with asking your question there.

Tom Ellison

 

[AB]

Tom,

This is actually an Access question. I've got a VBA app I wrote for a
spreadsheet, and I'm now trying to create a full-blown db app. I want to
import a few of the VBA forms I've already created so I don't need to rewrite
tons of code.

For clarification, the form is an actual VB object, not a spreadsheet. Is
it possible to import VB objects directly into Access for use with a
database? Or am I going to have to create this as a VB application with an
Access backend?

 

[RoyVidar]

AB wrote in message

I can't seem to import (through the File > Get External Data > Import menu)
an .frm file of a form I'm using in an Excel app. Is there some way to
import the .frm file that I don't know about?

To Access?

I don't know if I'd really wanted to do something like that, but try
exporting it from Excel (in the VBE - right click the userform in the
project explorer - Export file), then import it from VBE in Access.

 

[Brendan Reynolds]

Access has its own form model. It does not use the UserForms used by other
Office apps such as Word and Excel.

 

[AB]

Ah, that explains a lot. Thanks for the help.

Access has its own form model. It does not use the UserForms used by other
Office apps such as Word and Excel.

 

[Tom Ellison]

Thanks, Brendan. It also explains my confusion about the question.

Tom Ellison