Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I have been asked to find the differences between a recently developed ADP and a current working MDB version of an application.

    Is there a way to extract the VBA code behind the above mentioned objects so i can use a file compare program?

    Or is there a better way?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I have found a way to do it by looping thru all forms, the reports then modules using:
    Application.SaveAsText acForm, "Form name", etc

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Quote Originally Posted by patt View Post
    I have found a way to do it by looping thru all forms, the reports then modules using:
    Application.SaveAsText acForm, "Form name", etc
    Has anyone got a good file compare program?

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Try WIndiff.exe
    jsut google for more info

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Quote Originally Posted by kentg View Post
    Try WIndiff.exe
    jsut google for more info
    Thanks for your response but I omitted to say i already use Ultra Compare, it shows a side by side comparison.

    I tried Windiff, it doesn't show the differences as well as Ultra Compare so at this stage i will stick with Ultra Compare.
    .

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have you tried WinMerge? Works well for me.

    Winmerge.org
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Quote Originally Posted by ThreeCrow View Post
    Have you tried WinMerge? Works well for me.

    Winmerge.org
    I'll check it out, from what i have seen from an example on their site it looks remarkably like Ultra Compare.

    What i like mostly about Ultra Compare that WinMergedoesn't do is that it highlights letters that are different in lines where there are differences.

    There's another i have found called Compare It, this is as good if not better than Ultra Compare as it aligns text a lot better.

Posting Permissions

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