View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hershmab Hershmab is offline
external usenet poster
 
Posts: 35
Default Excel VBA 2003: how do I call an Analysis ToolPak function within

Analysis ToolPak is installed in my application and I need to use the result
of EOMONTH function in a UDF I am writing. These functions are clearly not
amongst the properties/methods of APPLICATION.WORKSHEETFUNCTIONS.

I tried this syntax:
PrevMthEnd = [atpvbaen.xla]!EOMONTH(Date, -1)
but it also does not work.

How should it actually be worded?