Excel Tabs

[Creating a Word shortcut in Excel]

How can I call anther Worksheet, Word and Outlook from a Tab in a worksheet?
If I right click on a tab it has a View Code option. I've tried puting the
path to the worksheet in there, but that doesn't work.

 

[JP]

What do you mean "call"? Do you mean "open"?

--JP

 

[Creating a Word shortcut in Excel]

Yes, I mean open. Thanks

What do you mean "call"? Do you mean "open"?

--JP

 

[Mike]

Sub CreateWordDoc()
Dim wrdApp As Word.Application

Set wrdApp = CreateObject("Word.Application")
With wrdApp
.Visible = True
.Documents.Add
End With

End Sub

 

[JP]

To start Word:

Sub StartWord()
Dim wdApp as Object
Set wdApp = CreateObject("Word.Application")
wdApp.Visible = True
End Sub

To start Outlook (late binding):

Sub StartOutlook()
Dim olApp as Object
Set olApp = CreateObject("Outlook.Application")
olApp.Visible = True
End Sub

To select another worksheet:

Worksheets("Sheet1").Range("A1").Select

Replace "Sheet1" with the actual name of the sheet you want to view.

All of this code should be placed in a standard module (see
http://www.rondebruin.nl/code.htm for placement assistance).

HTH,
JP