EOMONTH

[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!!!

 

[Tom Ogilvy]

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

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!!!

 

[Guest]

THANKS!!! That's the answer I needed!

 

[Earl Kiosterud]

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

 

[Peo Sjoblom]

Earl,

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