View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
kafoury123 kafoury123 is offline
external usenet poster
 
Posts: 2
Default opening excel through visual basic

sorry , but what should replace fullname in (oAddin.FullName) and do i write
oAddin with an o?!

"Bob Phillips" wrote:

I don't think that this will work,. Via automation, the addins are not
loaded, it is not just that their installed property is not set. You need to
explicitly load them

Dim oAddin

For Each oAddin In Application.AddIns
If oAddin.Name = "MATLAB.xla" Then
xl.Workbooks.Open(oAddin.FullName).RunAutoMacros 1
End If
Next


--

HTH

RP
(remove nothere from the email address if mailing direct)


"OJ" wrote in message
ups.com...
Does this work?

(assuming Set xlApp = CreateObject("Excel10.Application"))

xlApp.AddIns("MATLab").Installed = True

Hth,
OJ