LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Early vs Late Binding - Word

Read this John

http://www.erlandsendata.no/english/...baoleolebasics

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"John Wilson" wrote in message ...
I'm finally getting a taste (quite sour) of Office 2003.
It came with the two new PC's so I didn't have much of a choice.
In many (actually all) of the workbooks where I interact with Word,
I used Early Binding. Since the initial workbooks were created in
Office 2000, when someone with a later version saves the workbook
the Word Object reference is set to version 11.
I've already read through many of the threads by Chip, Rob, etc.
and it's beginning to sink in (but a lot slower than I would have
hoped).

Whilst still getting a handle on this, I would appreciate it if someone
could convert the following code to utilize Late Binding.
I can get some of it to work, but not all. Any help would be
appreciated.

Dim wordApp As Word.Application
Dim wordDoc As Word.Document
Dim wordRange As Word.Range
Dim FileNameAndPath As String
FileNameAndPath = ActiveWorkbook.path & "\Forms\Fax_Cover_Master.doc"
Set wordApp = CreateObject("Word.Application")
Set wordDoc = wordApp.Documents.Open(FileNameAndPath, ReadOnly:=True)

Thanks,
John



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Late Binding issue with Excel.Application object [email protected][_2_] Excel Discussion (Misc queries) 2 August 4th 09 08:10 AM
Late binding to Excel from Access causing Object error EagleOne@microsoftdiscussiongroups[_2_] Excel Discussion (Misc queries) 4 June 14th 08 12:45 AM
Formula that returns late, early or Ok accordingly to the period leslieyosbe Excel Discussion (Misc queries) 2 August 3rd 06 05:36 PM
VB Extensibility library and "late binding" Dennis Excel Discussion (Misc queries) 0 March 30th 05 10:51 PM
DAO objects with late binding in Excel? Chris Excel Programming 0 August 21st 03 07:28 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"