Converting from XP to 7

[Formulaoneman]

I have a large Access VBA application which interacts with Excel. My company is in the process of converting to Windows 7 using Office 2010 from XP and Office 2007. My user was testing and got the following error when the Excel spreadsheet tried to run a regression, "Runtime Error 1004, C:\Users\Allison1\Documents\ATPVBEAN.XLAM could not be found."

I verified that Analysis ToolPak(ANALYS32.XLL), and Analysis ToolPak - VBA(ATPVBEAN.XLAM) are active in Excel Options Add-ins. I even tried copying the add-ins into the folder, and still get the error.

What am I missing?

Thanks for the help.

 

[Formulaoneman]

I figured the problem out. Here's my solution:
I opened the spreadsheet that was having the problem, and the references were the same (other than release levels) between Excel 2007 and 2010. However, when I went into Excel 2010 with a generic workbook (i.e. “Book1” the user’s spreadsheet not open), the Add-ins weren’t installed. That’s kind of strange. So I activated the Add-ins, and saved “Book1.” That fixed the problem when I ran the application.