FRANCISCO SOUSA-PORTUGAL
New Member
- Joined
- Jul 23, 2010
- Messages
- 21
He liked to go from Excel to Word, I already have the data passed to the Word and just wanted to go to Word and print the document.
Sincerely
FS
Sincerely
FS
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Id like to jump from an Excel file to a Word document
- Thread starter FRANCISCO SOUSA-PORTUGAL
- Start date
Trevor G
Well-known Member
- Joined
- Jul 17, 2008
- Messages
- 6,842
- Office Version
- 365
- Platform
- Windows
You could either use a Hyperlink in a cell so you click it and it opens your word document or you could look to use some VBA CODE to open Word up.
Use Alt + F11 then go to the Tools Menu and select References, then scroll down the list until you find Microsoft Word Object Library and click the box. Then use some code like this:
Sub OpenWord()
Dim wrdApp as Word Application
Set wrdApp = CreateObject("Word.Application")
With wrdApp
.documents.open "Add the path and file extension to open the document"
.visible=True
End With
End Sub
Use Alt + F11 then go to the Tools Menu and select References, then scroll down the list until you find Microsoft Word Object Library and click the box. Then use some code like this:
Sub OpenWord()
Dim wrdApp as Word Application
Set wrdApp = CreateObject("Word.Application")
With wrdApp
.documents.open "Add the path and file extension to open the document"
.visible=True
End With
End Sub
Upvote
0
Similar threads
