VB & Excel

[Laurent Richer]

Hi there to you all and Happy New Year

I am a newbie in programming and I am looking for VB reference specific to
Mac version of Excel. Can anyone direct me.


Thanks all,

Laurent

 

[Jim Gordon MVP]

Hi,

There are lots of good sources. Among my favorites is
http://www.j-walk.com/ss/books/bookxl27.htm

and also
http://www.mcgimpsey.com/excel/index.html

VBA on Mac and Windows excel is very similar, but the Mac version
supports only those commands up to and including Visual Basic version 5.

The visual basic editor on the Mac is not as robust as the Windows
version, but the object editor and help are very good so you should be
able to find the code samples you need.

Mac Excel does not support Active-X, so skip anything you find about
this particular open source technology.

-Jim

 

[JE McGimpsey]

I am a newbie in programming and I am looking for VB reference specific to
Mac version of Excel. Can anyone direct me.

No such beast, I'm afraid. All Mac VBA versions are version 5.0, which
is equivalent to VBA in WinOffice97. So if you get a reference for
Office97, it should be 95% compatible.

VBA6, introduced in WinOffice2000, adds a few commands (e.g., Join,
Split, Round). One can emulate them in VBA5.

ActiveX controls are not supported on Macs. Use Forms Toolbar controls
instead.

There's a very few syntax differences (e.g,. the GetOpenFileName
method's FileFilter property). Looking in XL/VBA Help should get you
through any problem like that.

And you can always post here if you have specific questions.

 

[Laurent Richer]

Thanks all for the info, I'll look it up and get back to you all.

Laurent

 

[Laurent Richer]

Thanks for your response, i'll investigate and hopefully will come up with a
solution.
Laurent

 

[Rup]

Jim Gordon MVP a écrit :

Mac Excel does not support Active-X, so skip anything you find about
this particular open source technology.

-Jim

Active-X, an "open-source technology" ? Are you sure, are we talking
about the same "open-source" definition as in Linux, Gnu, etc. ?

Rup

 

[Jim Gordon MVP]

Yes

http://www.agentjim.com/MVP/ActiveX.htm

-Jim