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
|