Importing .frm Files

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?

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" 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?

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?

"Tom Ellison" wrote:

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" 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?

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.

--
Roy-Vidar

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

--
Brendan Reynolds
Access MVP

"AB" wrote in message
...
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?

"Tom Ellison" wrote:

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" 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?

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

"Brendan Reynolds" wrote:

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

--
Brendan Reynolds
Access MVP

"AB" wrote in message
...
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?

"Tom Ellison" wrote:

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" 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?

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

Tom Ellison


"AB" wrote in message
...
Ah, that explains a lot. Thanks for the help.

"Brendan Reynolds" wrote:

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

--
Brendan Reynolds
Access MVP

"AB" wrote in message
...
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?

"Tom Ellison" wrote:

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" 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?