Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word Library reference
Any idea what I have to change to make this work without have the MS Word
Object reference checked? OR is there a way to automatically select the word object library if the user does not have it checked? Set WordApp = CreateObject("word.application") 'open Word session WordApp.Visible = True 'Word visible during operation WordApp.Activate Set WordDoc = WordApp.Documents.Open(file_path) 'open Word doc On Error Resume Next With WordDoc.Content.Find With .Replacement End With .Execute findtext:="<release plan status", ReplaceWith:="Initial", _ Replace:=wdReplaceAll .Execute findtext:="<project/RIA ", ReplaceWith:="Project", _ Replace:=wdReplaceAll .Execute findtext:="<project#", ReplaceWith:=strProjNum & " ", _ Replace:=wdReplaceAll .Execute findtext:="<project name - or - <RIA name", _ ReplaceWith:=" " & strProjName, Replace:=wdReplaceAll .Execute findtext:="<mm/dd/yyyy hh:mm A ", ReplaceWith:=strRlsDate, _ Replace:=wdReplaceAll End With WordDoc.Tables(1).Rows(2).Range.Font.Color = wdColorBlue WordDoc.Tables(1).Rows(2).Range.ParagraphFormat.Al ignment = wdAlignParagraphCenter WordDoc.Tables(1).cell(2, 1).Range.text = "P & C Property Systems" WordDoc.Tables(2).Rows(2).Range.Font.Color = wdColorBlue WordDoc.Tables(2).cell(2, 1).Range.text = "1.0" WordDoc.Tables(2).cell(2, 2).Range.text = Date WordDoc.Tables(2).cell(2, 3).Range.text = "Created Document" WordDoc.Tables(2).cell(2, 4).Range.Font.Color = wdColorAutomatic On Error GoTo Err_WordDocs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming word tables or coding reference library with vba | Charts and Charting in Excel | |||
Add-ins and Reference library | Excel Programming | |||
Reference Library - Missing Library in a lower version. | Excel Programming | |||
adding reference to the Word-Library | Excel Programming |