Can I write an excel add-in using Xcode?

Question

I've written several very helpful excel add-ins using VBA. I'm using Excel for Mac 2011 Version 14.2.2 (120421). I'd like to sell the add-ins via a web site. Can I write the add-ins in Xcode or do I have to use C#?

Why don't you re-write them in another language like Java or Objective C? You can get libraries for those languages that can access excel documents just like you would from VBA (assuming that's what you're using currently). I think this would be better for selling them. — user377628
– user377628, Commented Jul 2, 2012 at 1:30
That's very helpful. So, I can write them in in Objective C? That's great news. Can you tell me where I can get the libraries for excel in objective C? — DBWeinstein
– DBWeinstein, Commented Jul 2, 2012 at 1:44
@Hassan is only correct as far as accessing the cells -you wont be able to have any Ribbon Buttons or Context menu's. @Aaron is correct: You cannot write Excel Add-Ins for Office Mac edition's. — Jeremy Thompson
– Jeremy Thompson, Commented Jul 2, 2012 at 3:06
i'm very confused. I've written VBA code create toolbars and saved the code as a .xlam (excel add in) file and they work great on my machine. Am I asking the wrong question. I want to packages these add-ins to sell them. What's the best way to do that? — DBWeinstein
– DBWeinstein, Commented Jul 2, 2012 at 3:21
Everyone writes Excel Add-Ins using C# VSTO or with VBA as xlam files. To clarify your asking if you can write add-ins in xcode or ObjectiveC and the answer is no. This Q is turning into a chameleon question. Better to ask a new question about packaging. — Jeremy Thompson
– Jeremy Thompson, Commented Jul 2, 2012 at 3:32

Aaron Brager · Accepted Answer · 2012-07-02 01:25:48Z

2

From Microsoft Support:

In Office 2011 for Mac, there is no concept of add-ins. So using Excel Add-In is not possible...

You'll need to use VBA or AppleScript to emulate the same behavior.

answered Jul 2, 2012 at 1:25

Aaron Brager

66.4k21 gold badges169 silver badges295 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aaron Brager Over a year ago

Here is documentation of the supported VBA commands in Office 2011: mac2.microsoft.com/vb/1033/default.aspx

DBWeinstein Over a year ago

I don't mean to be contrary, but i have definitely written add-ins using VBA and sent them to other people to use in excel. Maybe i'm not saying it correctly, but the other answer to my question seems to have answered me.

Collectives™ on Stack Overflow

Can I write an excel add-in using Xcode?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related