Excel for mac 2016 vba

broken image

It does not appear that this error occurs on Excel for Mac 2011. Run-time error ‘1004’: Method ‘SaveAs’ of object ‘_Workbook’ failed. For a few people, when this moment occurres, the VBA code in the workbook generates an error. One of the things the workbook does is save a separate Excel file on the user’s computer in a very specific folder, the first time the file is opened on that computer. Thus, I am struggling to figure out what’s causing it. However, a few people on Mac are reporting an issue that I cannot reproduce on any of the Mac’s I have access to.

broken image

I released the first version of the file publicly back in November, and for most people, it is working fine.

broken image

I’ve created a Macro-Enabled Excel workbook for using on Excel for Mac & Windows. This is my first time posting on this forum, and I'm not sure if this is the correct place to put this.