Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a macro to open another document | Excel Discussion (Misc queries) | |||
Using a macro to open another document | Excel Discussion (Misc queries) | |||
Macro to open specific document | Excel Discussion (Misc queries) | |||
Run a macro always I open an Excel Document | Excel Programming | |||
macro and button to open a word document from within excel | Excel Programming |