VBA differences PC/Mac

[Ferenc]

I'm trying to port a PC VBA app to MAC Excel v.X

So far I've found the following things which ain't there on the MAC:
-VBmodeless parameter for a dialog box (bummer)
-Source property of a list box control of a dialog box, so one could have it
automatically loaded from worksheet range of cells.

Anybody found others?
Is there a list collected somewhere of the platform dependent features?

Thanks In Advance

 

[JE McGimpsey]

I'm trying to port a PC VBA app to MAC Excel v.X

So far I've found the following things which ain't there on the MAC:
-VBmodeless parameter for a dialog box (bummer)
-Source property of a list box control of a dialog box, so one could have it
automatically loaded from worksheet range of cells.

Anybody found others?
Is there a list collected somewhere of the platform dependent features?

You can look under the "Differences between Excel VBA for Windows and
Excel VBA for Macintosh" Help topic... That will mostly tell you that
ActiveX isn't supported.

The vbModeless parameter isn't a Mac vs PC issue, it's a VBA5 vs VBA6
issue - WinXL97 doesn't have vbModeless, either. That said, any
VBA6-only function (e.g., Split(), Join(), Replace(), Round(), etc.)
will not work natively in MacVBA. I use conditional compilation (also in
Help) to add VBA5 versions of these functions in either XL97 or MacXL.

The filefilter parameter of, for example, the GetOpenFileName method,
works differently for Mac and Win. Again, I use conditional comp for
cross-platform apps.

If you drive other applications from XL, Macs only allow one instance of
an app to be running at a time, so you need to try GetObject before you
CreateObject.

There are few other gotchas, but I don't know anywhere there's a
comprehensive collection. Yet another topic for my list to add to my web
site...

 

[Ferenc]

Thanks,

Finally I found the differences page in the help, and you are right, it is
not very helpful beyond the obvious ActiveX reference.

I ran into the fileopen/filter difference way back in earlier version, and
that I expected too.

I stumbled on the known differences by browsing the VBA help while in the
VBA editor, under the individual controls - see clipping below.
It somehow tells me that it is a platform and not straight VB6 vs VB5
version issue.
Otherwise I would expect they would mention the VB 5.0 version somewhere,
and wouldn't even list the (not yet implemented) RowSource property

The MacTopia website is propaganda heavy and not developer oriented, so I'm
still looking for informative websites. I would liek to check out yours too.
Is there a favoured "watering hole" mac-excle vba developers congregate?

Thanks again,
ferenc

======================help clipping
RowSource Property
See Also Example Applies To Specifics
Specifies the source providing a list for a ComboBox or ListBox.
Syntax
object.RowSource [= String]
The RowSource property syntax has these parts:
Part Description
object Required. A valid object.
String Optional. The source of the list for the ComboBox or ListBox.

Remarks
The RowSource property accepts worksheet ranges from Microsoft Excel. This
property is not supported in Microsoft Office for the Macintosh.