using macro to open a workbook

[daniel chen]

Can anyone help me with creating a macro ? Please.
I know how to activate an opened workbook, save and close it using macro.
How do I creat a macro that will open a not-yet-open workbook ?
I don't mean to use a link.

 

[Steve Yandl]

Try something like:

Sub OpenABC()
Workbooks.Open Filename:="C:\test\abc.xls"
End Sub

Steve