How can I open the third sheet from another file

[Enescu Gabriel]

Hi, my name is Toni
1. I want to use an excelxp macro for open an other excel file directly to
the sheet number "n"?
2. In the same mod I want to open from excel a document from word templates.
Thank you in advance.

 

[Bob Phillips]

Hi Toni,

First part

Set oWb = Workbooks.Open Filename:="C:\myTes\myFile.xls"
oWb.Worksheets(3).Activate

On the second part, do you really mean you want to open a Word template from
within an Excel instance, or do you want to open a word template within a
Word instance, using Excel and VBA?

--

HTH

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

 

[Frank Kabel]

Hi
for the first one try something like the following:

sub foo()
dim fname as string
dim path as string
Dim WBook As Workbook
application.screenupdating = false
path = "C:\"
fname = "filename.xls"
On Error Resume Next
Set WBook = Workbooks(fname)
On Error GoTo 0
If WBook Is Nothing Then
Workbooks.Open Filename:= path & fname
Set WBook = Workbooks(filename)
End If
WBook.worksheets(3).activate
application.screenupdating = True
end Sub