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

[Murray Outtrim]

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

 

[Bob Phillips]

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)

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.

creating financial statements