Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i open a second workbook using a vba code | Excel Discussion (Misc queries) | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Code to open new workbook | Excel Programming | |||
Workbook Open code | Excel Programming | |||
Workbook Open code | Excel Programming |