Results 1 to 3 of 3

VBA Automation

Threaded View

xxx87 VBA Automation 05-10-2014, 02:35 AM
xxx87 Re: VBA Automation 05-11-2014, 04:41 AM
xxx87 Re: VBA Automation 05-10-2014, 04:46 AM
  1. #1
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    VBA Automation

    I got stuck at one place.If I compare 2 documents entirely(not page by page) how will I get the page numbers where we have the discrepancies.In the below mentioned code I want the page number to be return which are not matching with each other.I tried it but I failed.

    dim temp as string
    
    dim temp1 as string
    
    Set objWord = CreateObject("Word.Application")
    Set objDoc = objWord.Documents.Open(TextBox1.Text)
    
    temp = objDoc.Range(0, objDoc.Range.End)
    
    objWord.Quit
    Dim objword1 As Object
    Set objword1 = CreateObject("Word.Application")
    Set objDoc1 = objword1.Documents.Open(TextBox2.Text)
    temp1 = objDoc1.Range(0, objDoc1.Range.End)
    
    objword1.Quit
    If temp = temp1 Then
    MsgBox "Matched", vbInformation
    Else
    MsgBox "Not Matched", vbInformation
    End If
    Last edited by xxx87; 05-10-2014 at 04:37 AM. Reason: Added Code Tag

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need help with Vba IE automation
    By colonna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2013, 06:46 AM
  2. IE Automation
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2011, 01:45 PM
  3. help with some automation
    By ExcelNoob2008 in forum Excel General
    Replies: 2
    Last Post: 01-28-2010, 05:01 AM
  4. Automation help!
    By vicco in forum Excel General
    Replies: 2
    Last Post: 05-16-2008, 05:18 PM
  5. Automation using VBA
    By kingfisher007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2008, 07:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1