Hello,



I'm using Excel as a prototyping tool for medium to large engineering applications and would like to know whether it is possible to run the prototypes on Mac with Office 2016.

Some relevant features of these Excel workbooks are:

1. No formulas in cells, only VBA code.

2. More than 20000 lines of actual code.

3. A similar amount of comment lines.

4. Only standard ActiveX controls (buttons, comboboxes, etc.).

5. No forms (yet).

6. Connection to Access via ADODB and ADOX.

7. A few functions defined via 'Declare ... Lib ...', for example

Declare Function GetTickCount Lib "kernel32" () As Long


Thanks a lot,

agb2002

Short answer: no.

Macs don't run Access, or ActiveX controls, or Windows API calls. I can't recall whether ADO works - I suspect not.

Thank you, Debaser. That's what I imagined.