<div>
Hi,<br />
Make sure you have a reference to the atpvbaen.xla something like this:<br />
<br />
&nbsp;Set XlsObj = New Excel.Application<br />
&nbsp; &nbsp;XlsObj.Workbooks.Open (XlsObj.Application.librar<wbr />ypath &amp;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp;&quot;\Analysis\atpvbaen.xla&quot;)<br />
&nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; ' Runs the AutoOpen macro in the add-in<br />
&nbsp; XlsObj.Workbooks(&quot;atpvbaen<wbr />.xla&quot;).Run<wbr />AutoMacros<wbr /> (1)<br />
<br />
<br />
Good Luck!<br />
<br />
Gary
</div>


Hi,
Make sure you have a reference to the atpvbaen.xla something like this:

 Set XlsObj = New Excel.Application
   XlsObj.Workbooks.Open (XlsObj.Application.librarypath & _
       "\Analysis\atpvbaen.xla")
     
      ' Runs the AutoOpen macro in the add-in
  XlsObj.Workbooks("atpvbaen.xla").RunAutoMacros (1)


Good Luck!

Gary

<div>
THX<br />
After using the code you have provided, it still doesn't work. VBA reports that the object (which is Excel object) does not support the method COUPPCD or COUPNCD
</div>


THX
After using the code you have provided, it still doesn't work. VBA reports that the object (which is Excel object) does not support the method COUPPCD or COUPNCD

<div>
<div class="content wysiwyg-content">
I want use Excel worksheet functions COUPPCD and COUPNCD in my VBA code for Access. I have created the Excel object and use its &quot;worksheetfunction&quot; method to call COUPPCD and COUPNCD. But it fails. Can someone help me to solve the problem? Or if there is equivalent functions in VBA or Access?
</div>
</div>


I want use Excel worksheet functions COUPPCD and COUPNCD in my VBA code for Access. I have created the Excel object and use its "worksheetfunction" method to call COUPPCD and COUPNCD. But it fails. Can someone help me to solve the problem? Or if there is equivalent functions in VBA or Access?

Use Excel Worksheet Function COUPPCD and COUPNCD

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.