MS Office add-in for Mac OS

Question

I like to create an add-in for Office apps for Mac OS. I like to capture some events in Office apps like file open, file close, etc. I don't want Office Javascript add-in.

Is there some way with Applescript or objective-c or swift or something else?

Some starting point will help.

Answer 1

There are three types of add-ins:

• VBA add-ins. These have been around a long time. This is what you'll be creating if you've ruled out Office.js.
• COM add-ins. These only work under Windows.
• Office.js add-ins. This is the newest type of add-in, with the weakest support for Office features.

VBA is built into Office programs. To get started, choose Word>Preferences>View or Excel>Preferences>View and check Show developer tab. Then click on the Developer tab and choose Visual Basic to open the VBA editor. PowerPoint for Mac is missing the Developer tab, but you can access the VBA by choosing Tools>Macro>Visual Basic Editor.

VBA for Mac has a less complete and less documented object model than the Windows version. When searching for Mac-specific VBA information, include Word VBA "for Mac", Excel VBA "for Mac" or PowerPoint VBA "for Mac" in your search terms to make the results more relevant.

Answer 2

Hi @Shabari Pragash

There are two kinds of add-ins for Office for Mac: Office Add-ins from the Office Store (which use web technologies like HTML, CSS and JavaScript) and add-ins made by using Visual Basic for Applications (VBA).
For more details, please refer to "Get Add-Ins for Office for Mac".

So please refer to JohnKorchok's reply, VBA add-ins seem to be your needs.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---