Word 2007 (on Vista) crashes when using CreateObject in VBA

[Tim]

Can anyone help with this? I think it may be the config of my laptop,
but don't know what specifically.

I'm trying to open an app in VBA using CreateObject but Word crashes
every time with a 'Microsoft Office Word has stopped working' message.
Sample code here:-

Sub excelcalltest()
Dim objExcel
On Error GoTo Err
Set objExcel = CreateObject("Excel.Application") - it crashes once it
gets to this line
objExcel.Visible = True
Err:
MsgBox Err.description
End Sub

I'm not a programmer but know basics. I don't need anything ticked in
Tools/References do I? Could it be permissions in some way?

Cheers

Tim

 

[Tim]

Further info on this:-

Seems the problem relates to late binding in Word 2007, as the early
and late binding version of this script work in Outlook VBA

Tim