EOMONTH

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel Spreadsheet program which was given to me years ago that i would now like to use. I am using Excel97 and the program calculates loan payments. You enter a date and payment and it calculates the per day interest charge and gives you a new balance. This program has a macro with the line:
='C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY\Analysis\ATPVBAEN.XLA'!EOMONTH(B10,0)+1
I checked my computer and the file ATPVBAEN.XLA is located in the directory specified but when ever I open the file I get a message saying that it can not work because:
The name you specified may not be defined
The name you specified is defined as something other than a rectangular cell reference.

How do I correct this problem? is there a new/updated ATPVBAEN.XLA file which would have the name defined in it?
When I click through and use the program it seems to work but I would like to correct this problem. THANKS!!!
 
You should go to Tools=>Addins and make sure Analysis Toolpak is selected
(not Analysis Tookpak - VBA, doesn't make any difference whether that is
selected or not).

Then replace that entry with

=EOMONTH(B10,0)+1

ATPVBAEN.XLA is the Analysis Toolpak -VBA which is the same as the Analysis
Tookpak, but provides the analysis toolpak functions for use in VBA
routines; not in the worksheet. Not sure how you worksheet function got
mapped to this.

--
Regards,
Tom Ogilvy



Glenn said:
I have an Excel Spreadsheet program which was given to me years ago that i
Click to expand...
would now like to use. I am using Excel97 and the program calculates loan
payments. You enter a date and payment and it calculates the per day
interest charge and gives you a new balance. This program has a macro with
the line:
='C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY\Analysis\ATPVBAEN.XLA'!EOMONTH(B10,0)+1
I checked my computer and the file ATPVBAEN.XLA is located in the
Click to expand...
directory specified but when ever I open the file I get a message saying
that it can not work because:
The name you specified may not be defined
The name you specified is defined as something other than a rectangular cell reference.

How do I correct this problem? is there a new/updated ATPVBAEN.XLA file
Click to expand...
which would have the name defined in it?
When I click through and use the program it seems to work but I would like
Click to expand...
to correct this problem. THANKS!!!
 
Just so the new folks will know... :)

Lately, it seems we're losing our threading in these newsgroups. Glenn's
post ("Thanks") should have been posted as a reply to Toms, not as a reply
to his OP (original post). Just like this post is a reply to his "Thanks."
In cases where there are many replies in an OP, they become disjointed --
hard to tell which post a reply is talking about. This will help keep stuff
clear. I do believe.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Earl,

I belive it's due to the CDO interface many use, also seems that they link
from excel forum.
 
Back
Top