Using Cocoa API in VBA

[BlueCactus]

So, y'all are the 3 mac users, then? (hee hee...)

Cheek. I am NUMBER FOUR, I will have you know! (I'd rather be Number Six, but that's a different story.)

[BlueCactus]

kei,

If you look at the Excel VBA Help pages, there are occasional vague references to being able to call 'Mac code resources'. See, for example, the blurb on the Declare statement. What it all means is anyone's guess.

[mansky]

kei,
In case you haven't already found it, the bridge between VB and the Cocoa frameworks is via CamelBones in Perl. CamelBones is an Objective C bridge between Perl and Cocoa. I agree with shades and BlueCamel in starting with Applescript. Depending upon what you are trying to do, Applescript may suffice. If you need full assess to Cocoa, then CamelBones, via Perl, is the way to go.

I've called my Perl routines via Applescript from VB just fine. There is overhead involved, but it does give you access to the full scope of Perl/Cocoa and OSX from within Office.

You can check out CamelBones at Sourceforge:

http://camelbones.sourceforge.net/index.html


Ed