Excel VBA code analyzer

Joined
Nov 14, 2019
Messages
1
Reaction score
0
I have huge excel file with bunch of VBA modules. I need to rewrite it a bit and fix some bugs which are relevant only for MacOS. I want to see dependency diagram between modules, some visualization tools which can help me to understand which code snippet control specific tabs and objects and so on (there are over 30 excel sheets and a lot of buttons :)).

I've found some tools but Windows only. So, could you please, help me to find some tools for MacOS Mojave?
 

Cory Cooper

Moderator
Joined
May 19, 2004
Messages
11,102
Reaction score
492
Hello and welcome.

Unfortunately, in my experience it is best to simply use Excel with VBA modules in a Windows environment. You could use Parallels or Fusion to run Windows in a virtual machine, or Boot Camp to run it natively as a PC.

C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top