Error running regression Macro

[EnergyModeler]

Hello,

I have been working on automating a spreadsheet that contains a Regression Analysis. I have ran through it numerous times and it works just fine. However, when I send it to a coworker she gets an error saying "Run time error. Cannot run macro." She has macros enabled, but for whatever reason, it will not run. Any thoughts?? Thanks!

(This is where the error occurs)

Application.Run "ATPVBAEN.XLAM!Regress", Sheets("Data").Range("M5:M" & x1), _
Sheets("Data").Range("O5:S" & y1), False, False, , "", False, False, _
False, False, , False

 

[EnergyModeler]

The exact error she is receiving is:

Run-time error '1004':

Cannot run the macro ". The macro may not be available in this workbook or all macros may be disabled.

 

[Joe4]

It looks like it is referencing an Add In (that is what the "xlam" file extension suggests, see: https://www.lifewire.com/xlam-file-2622521).

Do they have access to this Add In on their computer, and has the Add In been enabled for them?

 

[EnergyModeler]

Yes, she has the Add In enabled. That was the first thing we checked. We ended up figuring it out.

As for the question I posted this morning that you locked, it was a completely different question. You can see (if you read closely) that she is not receiving an error at all. The macro does not execute fully and seems to stall without any error.

 

[Joe4]

Yes, she has the Add In enabled. That was the first thing we checked. We ended up figuring it out.

OK. We just ask that when that happens, you post back to the original thread, letting people know it has been solved, so that no one wastes time trying to solve it.
If you post how it was solved, that is helpful if people have the same issue and come across this thread.

As for the question I posted this morning that you locked, it was a completely different question. You can see (if you read closely) that she is not receiving an error at all. The macro does not execute fully and seems to stall without any error.

OK. Sorry about that. It look similar upon first glance.

I will remove the response and open it back up for you.