ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reference to Word document (https://www.excelbanter.com/excel-programming/330913-reference-word-document.html)

Tha BeatMaker[_2_]

Reference to Word document
 

Someone sent me this script:

Sub CreateNewWordDoc()
' to test this code, paste it into an Excel module
' add a reference to the Word-library
' create a new folder named C:\Foldername or edit the filnames in the
code
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim i As Integer

When using excel, how do i add a reference to the word-library?


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=376456


Nigel

Reference to Word document
 
Goto the VBA editor - Alt-F11 then use Tools-References - look for
Microsoft Word 10.0 Object Library and tick the check box. The version
number of the word version installed may be different depending on your set
up.



--
Cheers
Nigel



"Tha BeatMaker"
wrote in message
news:Tha.BeatMaker.1q2p6c_1117839910.7844@excelfor um-nospam.com...

Someone sent me this script:

Sub CreateNewWordDoc()
' to test this code, paste it into an Excel module
' add a reference to the Word-library
' create a new folder named C:\Foldername or edit the filnames in the
code
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim i As Integer

When using excel, how do i add a reference to the word-library?


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile:

http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=376456





All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com