addins excel

P

pierref

H

after many tests ..

in my access code

if i use shell "excel", excel opens with a new workbook and the addins functions appear in the vba editor

and if i use (and it's what i need
objxl.application.ope
objXL.Workbooks.Ad
Set WkBkTemp = objXL.Application.ActiveWorkboo

in this case, access opens with a new workbook but the addins functions don't appear

and i need to use the analysis tool addin in access. (file : ATPVBAEN.XLA

in my access code, I've tried to open this file with
objXL.Workbooks.Open "C:\Program Files\Microsoft Office\Office\Macrolib\Analyse\ATPVBAEN.XLA

but it doesn't worked
In fact it must be opened automatically by excel to work

thanks to help me ... i'm desperat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top