Error running regression Macro

EnergyModeler

New Member
Joined
Aug 16, 2019
Messages
7
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

New Member
Joined
Aug 16, 2019
Messages
7
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,731
Office Version
365
Platform
Windows
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

New Member
Joined
Aug 16, 2019
Messages
7
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,731
Office Version
365
Platform
Windows
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.
 

Forum statistics

Threads
1,084,838
Messages
5,380,198
Members
401,654
Latest member
etusch

Some videos you may like

This Week's Hot Topics

Top