Error when running regression using VBA?

[nobodyukno]

When I am active in the workbook and run the macro with the regression it works perfectly. However, when I try to run the macro through task scheduler or a vbs script automatically, I always get the following error: run time error 1004, run method of '_Application' failed.

I check and the Analysis Toolpak - VBA is enabled and I even have code in my macro to enable it if it's not already enabled. I also have to the Reference added as well that has to do with regression.

This only happens when I try to trigger the macro with task scheduler or something like that. I've tried so many things that just don't seem to work. The code that errors out is below:

Please Login or Register  to view this content.

Is there any way to get a macro with regression to run through task scheduler without getting this run time error? Or is there another way I can do the regression without using the toolpak?

[MrShorty]

My first thought -- is there a reason for running this in VBA? The Regress utility is built on the same linear regression algorithms as the LINEST() worksheet function. Unless there is some reason for doing this in VBA, my first inclination for linear regressions is to perform the regression with the LINEST() function and not use VBA at all. https://support.office.com/en-us/art...a-fa7abf772b6d

Even when I choose to do the regression in VBA, I will usually call the LINEST() worksheet function rather than use the regress utility. http://www.cpearson.com/excel/Callin...ionsInVBA.aspx