Opening Excel in Word

[Kas]

I currently have a macro that runs in excel but is
accessed from a menu in Word. My problem is that there
are some .xla files that need to be run at startup with
Excel to integrate it with our document management
software. Is there a way I can get these .xla file to
load when the Excel object loads from Word? Below is the
macro that I have now:

Sub StartTimesheet()
Dim xlapp As Object
Dim Timesheet As Object
Set xlapp = CreateObject("Excel.Application")
Set Timesheet = xlapp.Workbooks.Add("c:\program
files\softwise\forms\timesheet.xls")
xlapp.Visible = True
Set xlapp = Nothing
Set Timesheet = Nothing
End Sub

Any help on this would be greatly appreciated.

 

[Tom Ogilvy]

Load them yourself. (in your code)

They don't load when excel is started up using Ole Automation.

 

[Kas]

That's my question. I don't know how to load them.

 

[Tom Ogilvy]

Dim a as Addin
Set a = AddIns("Solver Add-In")
a.Installed = True

 

[Kas]

Thanks for all your help, but I keep getting an error
message that the add-in template is not valid. Any other
suggestions?

 

[Tom Ogilvy]

make sure you use the right name for it. See help for details.

Just like if I called you Pete, you wouldn't answer.

 

[Dave Peterson]

You rang?

(well, it made me laugh.)

 

[Kas]

I exhausted Help, and it still says that the add-in
template is not valid. The addin is in the right place.
I checked to make sure that the name was correct. Maybe
I'm missing a step? I'm about to pull my hair out.