need code to open new excel workbook

[ivan]

created a vb button in excel but want it to open an excisting workbook
tryed macro didnt work ? please help need code "beginner"

 

[David McRitchie]

Record a macro

Workbooks.Open Filename:="C:\bk1\h\excel2k\merge.xls"



--

 

[N10]

Try this in yer button with an appropriate file name


Sub Macro1()
'
Workbooks.Open Filename:="C:\MYWORKBOOK.xls"

End Sub

best N10