Zoom API access through Excel VBA macros

API and Webhooks
1

Description
I have a zoom account and I use my windows desktop. I want to be able to write an Excel macro that can create new Zoom meetings through my excel macro. However, I dont find any DLLs in the Tools…Reference menu in the VBA editor window.

Which version?
Microsoft Excel 2016

To Reproduce(If applicable)
Steps to reproduce the behavior:

  1. Go to ‘…’
  2. Click on ‘…’
  3. Scroll down to ‘…’
  4. See error

Screenshots
If applicable, add screenshots to help explain your problem.

Device (please complete the following information):

  • Device Spec: [e.g. PC, Mac]
  • OS: [e.g. MacOS]
  • Version [e.g. 10.15.1]

Additional context
If not through VBA macro, is there a Windows command line interface that I can call Zoom to create a meeting invite etc?

2

Hey @natarajansk,

Your best bet is to use the Create Meeting API.

Thanks,
Tommy

3

Hi Tommy,

Thank you for your response.

I visited the link but still could not get an idea of how to integrate with an Excel VBA macro. Is there an command line call that I can make to create a meeting? Then I can make that command line call from VBA. Also, not clear how to get authenticated first before requesting for creating a meeting.

Do you have a sample VBA code?

Best Regards
Natarajan SK

4

Hi @natarajansk we don’t have an official Powershell library, but here is a community-built option you may be interested in: