I am trying to automate running of regression macros in Excel. I used the
"record" method to create one. But everytime I run the "recorded" regression
macro, I get the error message:

"Run-time error '1004':
'ATPVBAEN.XLA' could not be found. Check the spelling of the file name, and
verify that the file locations is correct.

If you are trying to open the file from your list of most recently used
files on the File menu, make sure that the file has not been renamed, moved,
or deleted."

I have searched my hard drive and this file (ATPVBAEN.XLA) is on my drive.
Does anyone know what I am doing wrong?

Mega Thanks!!

Confused VB Person -

Maybe, with a code module active, VBE | Tools | References | check box or
Browse to ATPVBAEN.XLA

- Mike

www.mikemiddleton.com

++++++++++++++++++

"Confused VB Person" wrote in
message ...
I am trying to automate running of regression macros in Excel. I used the
"record" method to create one. But everytime I run the "recorded"
regression
macro, I get the error message:

"Run-time error '1004':
'ATPVBAEN.XLA' could not be found. Check the spelling of the file name,
and
verify that the file locations is correct.

If you are trying to open the file from your list of most recently used
files on the File menu, make sure that the file has not been renamed,
moved,
or deleted."

I have searched my hard drive and this file (ATPVBAEN.XLA) is on my drive.
Does anyone know what I am doing wrong?

Mega Thanks!!