Form Export / Import

[KevCarter]

Running Excel 2011 on Mac OS 10.9.1.

I have a code module and form I would like to move to another workbook. I export the code and the form with no problem. I can import the code into the new workbook, but it won't recognize my form files to let me import them. Is this a known issue?

Thanks,
Kevin

[SamT]

What is a "Form file?"

In Windows, I can drag a form from one Book to another using the Project Explorer Pane in the VBA. Mac's :dunno

[KevCarter]

What is a "Form file?"

In Windows, I can drag a form from one Book to another using the Project Explorer Pane in the VBA. Mac's :dunno

Sam, when you Export a form or procedure, a "file" is created that should be able to be imported into another workbook.

I've actually found the VBA / Mac experience so frustrating, I've installed Parallels and Windows on my MacBook. I love the Mac, for EVERYTHING other than Office. VBA is so much better under Windows that I'm still happy even adding the extra overhead...

Kevin

[SamT]

OK. Form files = FormName.frx and FormName.frm files. ( in windows )

ps: is this thread solved?

Thanks

[KevCarter]

OK. Form files = FormName.frx and FormName.frm files. ( in windows )

ps: is this thread solved?

Thanks

The problem was solved by switching operating systems, but still there for folks using VBA with MacOS.

Kevin

[SamT]

thanks again.
Sam

[Aflatoon]

FYI, I can import and export userforms with no problem in Excel 2011 (14.3.9).

[KevCarter]

FYI, I can import and export userforms with no problem in Excel 2011 (14.3.9).

Hmmm, must be a problem on my system... Glad all is well with yours!

Kevin

[Aflatoon]

What exactly happens when you try?

[KevCarter]

What exactly happens when you try?

When selecting "Import" the dialog comes up, but won't let me select the form file, the file just stays grayed out. Works perfectly using the same workbook and same form when running under windows and Excel 2010...

Kevin

[Aflatoon]

Interesting. Is it a particular form, or any form? Also, was it created in Mac or Windows originally?

[KevCarter]

Interesting. Is it a particular form, or any form? Also, was it created in Mac or Windows originally?

Any form. Created on Mac.

[Aflatoon]

Which build of 2011?

[KevCarter]

Which build of 2011?

14.3.9