G
G.R. Toro
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
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