VBA-Excel for Mac

Hi guys,

Just a quick one. There is a difference between Excel on Mac and on WIndows?
I know how to do programming on Windows, but i think that on MAc, maybe there are other differences in the VBA field.

If so, can someone please show me a guide on what is difference in the VBA code is? or some docs that show the delta?

Thank you,
Ionut

VBA that works within Excel is the same. Sorry if this obvious, but it is the VBA codes that reach outside of the Excel scope to operate that are different. The simplest example is selecting a file on the hard drive.

This is a standard module I add for clients that need both MAC and PC. The functions do the same thing, provide a popup for selecting a file for some other reason, usually to open or import...

Please Login or Register  to view this content.

Then, in the main macros, I test for the OS of the computer running the macro, then call the appropriate version:

Please Login or Register  to view this content.

ok thank you JB!

Hi,

There are also syntax differences with VBA within Excel too, such as parameters that don't apply on the Mac (e.g. SearchFormat in the Find method). Additionally ActiveX controls don't work at all; API calls may or may not work but will definitely require rewriting; there is sandboxing on the Mac to work around too. All of this also varies between Mac versions.

Originally Posted by xlnitwit

Hi,

There are also syntax differences with VBA within Excel too, such as parameters that don't apply on the Mac (e.g. SearchFormat in the Find method). Additionally ActiveX controls don't work at all; API calls may or may not work but will definitely require rewriting; there is sandboxing on the Mac to work around too. All of this also varies between Mac versions.

Thank you xlnit! Where can i find some documentation about this? Have a great day!

I am not aware of any official documents- Ron de Bruin's website is very useful though.