Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare word document in excel
Private Sub Start_Click()
Dim Word As Object Set Word = CreateObject("Word.application") Dim name, name2 As String Application.DisplayAlerts = False Word.Documents.Open (OfFile), ReadOnly:=True Word.Visible = True name = Word.ActiveDocument.name Word.Documents.Open (rfFile), ReadOnly:=True Word.Visible = True name2 = Word.ActiveDocument.name Word.Activate Application.CompareDocuments OriginalDocument:=Documents(name), _ RevisedDocument:=Documents(name2), _ Destination:=wdCompareDestinationNew, _ Granularity:=wdGranularityWordLevel, CompareFormatting:=True, _ CompareCaseChanges:=True, CompareWhitespace:=True, CompareTables:=True, _ CompareHeaders:=True, CompareFootnotes:=True, CompareTextboxes:=True, _ CompareFields:=True, CompareComments:=True, CompareMoves:=True, _ RevisedAuthor:="KkK", IgnoreAllComparisonWarnings:=False ActiveWindow.ShowSourceDocuments = wdShowSourceDocumentsBoth End Sub How can i compare two word document in excel , then display result in Microsoft word??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare word document in excel
Isn't that what your macro is doing? what else do you need?
"KK" wrote: Private Sub Start_Click() Dim Word As Object Set Word = CreateObject("Word.application") Dim name, name2 As String Application.DisplayAlerts = False Word.Documents.Open (OfFile), ReadOnly:=True Word.Visible = True name = Word.ActiveDocument.name Word.Documents.Open (rfFile), ReadOnly:=True Word.Visible = True name2 = Word.ActiveDocument.name Word.Activate Application.CompareDocuments OriginalDocument:=Documents(name), _ RevisedDocument:=Documents(name2), _ Destination:=wdCompareDestinationNew, _ Granularity:=wdGranularityWordLevel, CompareFormatting:=True, _ CompareCaseChanges:=True, CompareWhitespace:=True, CompareTables:=True, _ CompareHeaders:=True, CompareFootnotes:=True, CompareTextboxes:=True, _ CompareFields:=True, CompareComments:=True, CompareMoves:=True, _ RevisedAuthor:="KkK", IgnoreAllComparisonWarnings:=False ActiveWindow.ShowSourceDocuments = wdShowSourceDocumentsBoth End Sub How can i compare two word document in excel , then display result in Microsoft word??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare word document in excel
Consider this:
http://www.softinterface.com/MD%5CDo...n-Software.htm It's free and it works great! HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Joel" wrote: Isn't that what your macro is doing? what else do you need? "KK" wrote: Private Sub Start_Click() Dim Word As Object Set Word = CreateObject("Word.application") Dim name, name2 As String Application.DisplayAlerts = False Word.Documents.Open (OfFile), ReadOnly:=True Word.Visible = True name = Word.ActiveDocument.name Word.Documents.Open (rfFile), ReadOnly:=True Word.Visible = True name2 = Word.ActiveDocument.name Word.Activate Application.CompareDocuments OriginalDocument:=Documents(name), _ RevisedDocument:=Documents(name2), _ Destination:=wdCompareDestinationNew, _ Granularity:=wdGranularityWordLevel, CompareFormatting:=True, _ CompareCaseChanges:=True, CompareWhitespace:=True, CompareTables:=True, _ CompareHeaders:=True, CompareFootnotes:=True, CompareTextboxes:=True, _ CompareFields:=True, CompareComments:=True, CompareMoves:=True, _ RevisedAuthor:="KkK", IgnoreAllComparisonWarnings:=False ActiveWindow.ShowSourceDocuments = wdShowSourceDocumentsBoth End Sub How can i compare two word document in excel , then display result in Microsoft word??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare word document in excel
The application.CompareDocuments wasn't not work .....why ?
"Joel" wrote: Isn't that what your macro is doing? what else do you need? "KK" wrote: Private Sub Start_Click() Dim Word As Object Set Word = CreateObject("Word.application") Dim name, name2 As String Application.DisplayAlerts = False Word.Documents.Open (OfFile), ReadOnly:=True Word.Visible = True name = Word.ActiveDocument.name Word.Documents.Open (rfFile), ReadOnly:=True Word.Visible = True name2 = Word.ActiveDocument.name Word.Activate Application.CompareDocuments OriginalDocument:=Documents(name), _ RevisedDocument:=Documents(name2), _ Destination:=wdCompareDestinationNew, _ Granularity:=wdGranularityWordLevel, CompareFormatting:=True, _ CompareCaseChanges:=True, CompareWhitespace:=True, CompareTables:=True, _ CompareHeaders:=True, CompareFootnotes:=True, CompareTextboxes:=True, _ CompareFields:=True, CompareComments:=True, CompareMoves:=True, _ RevisedAuthor:="KkK", IgnoreAllComparisonWarnings:=False ActiveWindow.ShowSourceDocuments = wdShowSourceDocumentsBoth End Sub How can i compare two word document in excel , then display result in Microsoft word??? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare word document in excel
Private Sub Start_Click()
Dim Word As Object Set Word = CreateObject("Word.application") Dim name, name2 As String Application.DisplayAlerts = False Word.Documents.Open (OfFile), ReadOnly:=True Word.Visible = True name = Word.ActiveDocument.name Word.Documents.Open (rfFile), ReadOnly:=True Word.Visible = True name2 = Word.ActiveDocument.name Word.Activate Word.Documents(rfFile).Select Word.CompareDocuments OriginalDocument:=Documents(name), _ RevisedDocument:=Documents(name2), _ Destination:=wdCompareDestinationNew, _ Granularity:=wdGranularityWordLevel, CompareFormatting:=True, _ CompareCaseChanges:=True, CompareWhitespace:=True, CompareTables:=True, _ CompareHeaders:=True, CompareFootnotes:=True, CompareTextboxes:=True, _ CompareFields:=True, CompareComments:=True, CompareMoves:=True, _ RevisedAuthor:="KK", IgnoreAllComparisonWarnings:=False Word.ActiveWindow.ShowSourceDocuments = wdShowSourceDocumentsBoth Word.Visible = True Word.Documents(OfFile).Close Word.Documents(rfFile).Close Application.DisplayAlerts = True Word.Quit Set Word = Nothing End Sub Now i can compare the documents , but only once ,then show the run time error "462",The remote server machine does not exist or is unavailable. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA Programming: Word Document Compare? | Excel Discussion (Misc queries) | |||
How can I convert an Excel document to a Word Document | Setting up and Configuration of Excel | |||
change excel document into word document | Excel Discussion (Misc queries) | |||
convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
How to change a excel document into a word document? | Excel Discussion (Misc queries) |