Printable View
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
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.Quote:
Originally Posted by SamT
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
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.Quote:
Originally Posted by SamT
Kevin
thanks again.
Sam
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!Quote:
Originally Posted by Aflatoon
Kevin
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...Quote:
Originally Posted by Aflatoon
Kevin
Interesting. Is it a particular form, or any form? Also, was it created in Mac or Windows originally?
Any form. Created on Mac.Quote:
Originally Posted by Aflatoon
Which build of 2011?
14.3.9Quote:
Originally Posted by Aflatoon