LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
1004 error when using ATPVBAEN.XLAM!Regress Allan_Urban Excel Programming 7 September 25th 09 02:31 PM
Custom Excel 2007 Tab disappears when editing an XLAM add-in file JeffreyW Excel Programming 10 April 8th 09 12:32 AM
Crashing Bug in Solver.XLAM for Excel 2007??? Michael[_40_] Excel Programming 5 December 7th 07 11:01 PM
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003 Duke Carey Excel Programming 3 November 20th 07 03:48 PM
Problem with ATPVBAEN.XLA Zaman Excel Programming 2 December 29th 06 08:16 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"