need code to open new excel workbook
 

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

need code to open new excel workbook
 

Record a macro

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



--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

need code to open new excel workbook
 

Try this in yer button with an appropriate file name


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

End Sub

best N10 :)


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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004