ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with ATPVBAEN.XLAM in Excel 2007 (https://www.excelbanter.com/excel-programming/439271-problem-atpvbaen-xlam-excel-2007-a.html)

G.R. Toro

Problem with ATPVBAEN.XLAM in Excel 2007
 
I am trying to run a macro that contains a call to ATPVBAEN.XLAM to generate
some random numbers. The macro was originally written in Excel 2003 (using
ATPVBAEN.XLA) and I am trying to port it to 2007. The macro stops at the
line containing ATPVBAEN.XLAM and reports error 1004 (related to not finding
the program or the program not being authorized).

I enabled the"Data Analysis" and "Data Aalysis VBA" add in Excel. In the
VBA window, the reference to ATPVBAEN.XLS is checked in the References
section. The add-ins section in the VBA page is blank.

I recorded a simpler macro in Excel 2007 to generate some random numbers,
and I am getting the same error.

I would appreciate any suggestions.

Gabriel




All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com