is it possible to open a word doc using a button that i have put onto a
excel worksheet

Attach this macro to the button
Sub test()
Set wrdApp = CreateObject("Word.Application")
'Uncomment the next line to open a specific document and change the path and
name
'Set wrdDoc = wrdApp.Documents.Open("C:\Doc1.doc")
wrdApp.Visible = True
End Sub

uk" wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet

Maybe assigning a hyperlink to the button would work ok???

uk wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet

--

Dave Peterson

hello i have tried the macro but i keep getting erreor on the set wdrApp
second line

"Sheeloo" wrote:

Attach this macro to the button
Sub test()
Set wrdApp = CreateObject("Word.Application")
'Uncomment the next line to open a specific document and change the path and
name
'Set wrdDoc = wrdApp.Documents.Open("C:\down.doc")
wrdApp.Visible = True
End Sub

uk" wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet

Sorry I forgot to add that you must pick Microsoft Word 11.0 from
ToolsReferences in the VB editor to execute Word commands.

See VB Help topic "Controlling One Microsoft Office Application from Another"
for more information.

Also if you have set Option Explicit then declare
Dim wrdApp As Word.Application
uk" wrote:

hello i have tried the macro but i keep getting erreor on the set wdrApp
second line

"Sheeloo" wrote:

Attach this macro to the button
Sub test()
Set wrdApp = CreateObject("Word.Application")
'Uncomment the next line to open a specific document and change the path and
name
'Set wrdDoc = wrdApp.Documents.Open("C:\down.doc")
wrdApp.Visible = True
End Sub

uk" wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet

hello Sheelo

ican now open a word doc but the page is empty the doc that i am trying to
open is not opening

"Sheeloo" wrote:

Sorry I forgot to add that you must pick Microsoft Word 11.0 from
ToolsReferences in the VB editor to execute Word commands.

See VB Help topic "Controlling One Microsoft Office Application from Another"
for more information.

Also if you have set Option Explicit then declare
Dim wrdApp As Word.Application
uk" wrote:

hello i have tried the macro but i keep getting erreor on the set wdrApp
second line

"Sheeloo" wrote:

Attach this macro to the button
Sub test()
Set wrdApp = CreateObject("Word.Application")
'Uncomment the next line to open a specific document and change the path and
name
'Set wrdDoc = wrdApp.Documents.Open("C:\down.doc")
wrdApp.Visible = True
End Sub

uk" wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet

Did you remove the comment indicator (') from the following line
'Set wrdDoc = wrdApp.Documents.Open("C:\down.doc")

You also need to change the path and name to your document
uk" wrote:

hello Sheelo

ican now open a word doc but the page is empty the doc that i am trying to
open is not opening

"Sheeloo" wrote:

Sorry I forgot to add that you must pick Microsoft Word 11.0 from
ToolsReferences in the VB editor to execute Word commands.

See VB Help topic "Controlling One Microsoft Office Application from Another"
for more information.

Also if you have set Option Explicit then declare
Dim wrdApp As Word.Application
uk" wrote:

hello i have tried the macro but i keep getting erreor on the set wdrApp
second line

"Sheeloo" wrote:

Attach this macro to the button
Sub test()
Set wrdApp = CreateObject("Word.Application")
'Uncomment the next line to open a specific document and change the path and
name
'Set wrdDoc = wrdApp.Documents.Open("C:\down.doc")
wrdApp.Visible = True
End Sub

uk" wrote:

is it possible to open a word doc using a button that i have put onto a
excel worksheet