Can an Excel Application be written for Mac?

[JK]

Forgive me if this isn't the correct forum, but there are so many experts
here, I'm hoping someone can advise me.

Several Mac users have wanted to install my Excel Application but weren't
able to. What do I have to do (inside VBA or otherwise) to make a Mac
version of my program? Perhaps it's not worth the effort, but I have no
idea. Hopefully someone knows.

Thank you.
Jim Kobzeff

 

[theDude]

Hi Jim,

It's certainly possible to create Excel apps for the Mac. In VBA,
certain methods, properties etc. require a different syntax for Mac and
others aren't available for Mac, while others are ONLY Mac-specific.
Without knowing what your particular application does, it's hard to
point you in the right direction.

I recently opened an Excel app I created in Excel (2000) for Windows on
my Mac (running Office 2004 for Mac) and it mostly worked. I had some
issues with a multipage user form, but was able to correct it.

You might want to provide details of your app & your VB code so others
can help you sort it out.

Hope this helps,
theDude

 

[Ken Johnson]

Hi Jim,
Mac VB is an earlier version.
Mac VB doesn't have ActiveX controls, so if your application uses them
you have to replace them with controls from the Forms toolbar.
There are some other differences I have encountered, but they might not
affect your application, eg IncrementLeft 0.75 works on PC but on my
iMac it has the same efect as IncrementLeft 1
You need to post your code to get a complete answer to your question.

Ken Johnson

 

[JE McGimpsey]

As others have said, it is certainly possible. The VBA version is VBA5
for all MacXL versions, so if it works on WinXL97 (and contains no
ActiveX controls) it will generally work in MacXL.

I make part of my living writing cross-platform applications...

You can find Mac-specific help in the

microsoft.public.mac.office.excel

newsgroup.

 

[JK]

Thank you all.

To answer theDude, I make a toolbar (hiding Excel's), use application calls
like Application.Dialogs(xlDialogSaveAs and xlDialogFindFile), use Data
Validation and conditional formatting. Other than that, typical spreadsheet
functions (i.e., IF(ISERROR()) etc).
Regards,
Jim Kobzeff

 

[theDude]

Hi Jim,

Bad news - the FindFile (either method or xlDialog) is no longe
supported in Excel for Mac, so I think you'll need another solution.
Click this link in the newsgroup from JE McGimpsey:

http://tinyurl.com/lh8m8

then clink on the link "Show quoted text" at the bottom of the linke
page...

theDud