Actually after playing around I have the following - .

I now have within VBA

Sub OpenWorkbook()

Workbooks.Open Filename:="E:\Excel Test\testOne.xls", UpdateLinks:=3
Application.DisplayAlerts = False


End Sub

Now this works fine when I do it from an open book. But I would like
it to happen when the actual file opens .....any ideas?

Cheers

Karti
;)