vba - How to opening a file (*.doc *.xls)
 

Is there away of opening another document using a macro?
I want to create a button that will open an existing file.
I also want the macro to select select a specific sheet with in th
file

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

vba - How to opening a file (*.doc *.xls)
 

Murray,

Dim oWb As Workbook

Set oWb = Workbooks.Open Filename:="c:\My Documents\MyFile.xls"
oWb.Worksheets(1).Activate

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Murray Outtrim" wrote in
message ...

Is there away of opening another document using a macro?
I want to create a button that will open an existing file.
I also want the macro to select select a specific sheet with in the
file.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements