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