Read the responses to Michelle Hanan's Opening doc in macro that was posted
on 7/12

"Todd" wrote in message
...
How do I write a macro to open a document? I tried to record a macro and
go
this macro that selects a cell and follows a hyperlink. But I would like
to
put the address of the doc. into the macro and not have the hyperlink in a
cell on the document.

Sub OpenTemplate()
Range("AH1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveWindow.ActivateNext
End Sub


Thanks,


Todd