#How to use vba in excel 2016 on mac how to#

Use your favourite spreadsheet app on both platforms without fear. However, IT has forced me to 'upgrade' to Excel 2016, and now the following line fails: set (Type:msoControlPopup,Temporary:true) This is because Controls.Add now returns a CommandBarControl object instead of a CommandBarPopup object.

I had to change the file path (obviously) but the other change needed is the format in which apple recognises path. ActiveWorkbook.

#How to use vba in excel 2016 on mac how to#

All you wanted to know about Microsoft Excel on Mac is here! Learn what basic modifications this version of Excel has and what is missing in comparison with Windows version. I am currently in the process of writing a VBA macro at work however I have run into a problem which I am hoping you can help me with.All I am trying to do is simply run an applescript app from e. I developed a macro/VBA script in Excel (running on wondows) and need to implement it on my customers machine who has a mac book. I'm currently using this piece of Code so that I uses the Default browser to open the link, but need help on how to close the browser.