PDA

View Full Version : Windows and Mac difference...Code wise



austenr
12-21-2006, 10:15 AM
What are the differences in coding VBA on a Mac and getting it to run on Windows. I believe I saw a post on here once that the differences were subtle. Any one know?

Zack Barresse
12-21-2006, 10:56 AM
Hmm, I don't remember them all, but I do remember that Macs do not support ActiveX controls, Runtime Script and some other controls.

Here is a good discussion pertaining to this from earlier this year:
http://www.dailydoseofexcel.com/archives/2004/08/11/controls-activex-vs-forms/
Also check out:
http://tinyurl.com/wdgcr
http://tinyurl.com/y5jozy
http://tinyurl.com/yx2cz3

In Excel 2001 for Mac, you cannot insert a Microsoft Data Map into a worksheet. There is no Map tool on the Standard toolbar, and the Map menu command does not appear on the Insert menu. (Reference (http://support.microsoft.com/kb/843305))

austenr
12-21-2006, 11:01 AM
Thanks Zack. Guess Bill still doesn't want to play fair with Steve. Was thinking about buying a Powerbook. Mainly for the reason there are far less bugs and issues with the OS. Happy holidays!!!:xnoel:

Zack Barresse
12-21-2006, 11:23 AM
I want an iMac. ;)

austenr
12-21-2006, 11:30 AM
Yea. IMHO they make a far superior product.

Brandtrock
12-21-2006, 11:32 AM
Of course Zack beat me to an answer.

Here is a link to a thread where Shades answered a similar question I asked.

Shades reply (http://www.vbaexpress.com/forum/showthread.php?t=565)

HTH

tpoynton
12-21-2006, 11:52 AM
I have an xla file that runs on both PC and Mac platforms. I ran into a few minor issues. One that I seem to recall had to do with unloading userforms; userform.hide did not work, but 'unload me' did. Also, if I recall, Excel 2001 for mac didnt come with the data analysis toolpak? Or perhaps it just wasnt installed by default. The mac also doesnt display menu icons if you use VBA to add menubar items (it doesnt show any menu icons, unlike windows). It doesnt affect performance in any way. It's been over a year since I grappled with any of this stuff...

There were a few others that I have since forgot, and if I have any of these wrong, someone please correct me! My point, however, is that workarounds for the differences were relatively easy to find.