using macro to open a workbook

  • Thread starter Thread starter daniel chen
  • Start date Start date
D

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.
 
Try something like:

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

Steve
 
Back
Top