Desktop

Ask something
Discussion Locked

Excel Invoking Word (Office 97)

0 helpful
3 replies

by wattsnew

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello helpmates!
I received this question from a co-worker today and wondered if anyone out there can offer wisdom.

"do you know how to build some magic into an Excel spreadsheet that would allow the client to press a button and have a Word template pop-up for them automatically?"

Thanks.

3 replies

by dklippert

Put a command button on the worksheet using the Forms toolbar.
Assign this macro to the button:

Sub OpenTemplate()

Set WordApp = CreateObject("Word.Application")

WordApp.Visible = True

Set WordDoc = WordApp.Documents.Add("c:\program files\microsoft office\templates\1033\brochure.dot")

End Sub

I know the Set WordDoc line is going to wrap. You place the path to the template following .Add
Use quotes if there are any spaces.

This discussion is closed to new replies.