I am unable to load a custom add-in on Mac that was created on Windows

I am currently working on an add in which, until now, was only used on Windows. I am attempting to make it cross-platform. Unfortunately, when pull my add in from git and attempt to load it in Excel on my Mac, I receive an error:

Alert

Excel cannot open the file 'myfile.xlam' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

I then receive a second message box that states:

Microsoft Excel cannot access the file 'myfile.xlam'. There are several possible reasons:

- The file name or path does not exist.

- The file is being used by another program.

- The workbook you are trying to save has the same name as a currently open workbook.

Regarding possibility 1, I know the file exists because I just pointed the add-in settings to it. As far as possibility 2, to the best of my knowledge there is no other program using the add-in, and I don't see how there could be. Regarding 3, I am not trying to save the file, so this is not the issue.

I also have checked that the file format and extension are valid and that they match eachother.

Curiously, if I move back to my Windows machine, set isAddin = False and save the file as an xlsm file, I can send it to my Mac machine, open it in Excel with no problems, set isAddIn = True and save it as an xlam on that machine. It will then load the add-in without any issue, as long as I save it where I intend to keep it. If I move the file elsewhere it becomes a gamble as to whether or not it loads. For example, after doing this, the files did not load at first and then loaded later on.

I'm guessing this issue has something to do with Excel on Mac having stricter protections when it comes to files not created on its system, but if this is the case, I'm not sure how to address it. In the security settings I have set Macro Security to "Enable all macros", Developer Macro Settings has "Trust access to the VBA project object model" checked, and Document-specific Settings has "Use Microsoft online service to open certain files" checked.

I'm at a loss as to where to go from here, and I'd really appreciate any input anyone has in an attempt to address this issue. Thanks in advance.

P.S. On an unrelated note, I wasn't sure if this should go in this category or the "Other Platforms" category. If it should go in the other, please let me know and I will post it there instead

Hi MarvinP,

I appreciate the reply! I'm not sure exactly what you mean however. The add-in is a custom created proprietary add-in at my job. There are actually more than one and the first is responsible for loading the others. As far as copying the VBA code from the Mac to a module on windows, I'm also unclear on what you need. The code for the add-ins are spread out over several modules that were originally created on Windows. Its when attempting to use that add-in in Excel on a Mac that I get the error and the add-in wont load. Sorry if I'm misunderstanding you here.