Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2010
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dear all,

    im stuck in vba for last 2 days.
    i want to perform editing(find and replace) module(s) and macro(s) from different access database(s).

    no progress in editing ( find/replace text ) macro,

    well this is my code for replacing word in module ( please see attachment )
    its only works when in the same database,
    but as soon as i add 'Set Dbs = OpenDatabase(dbname) it didnt work..

    any help would be great!

    Thank!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Unfortunately your attachment doesn't appear to have been uploaded. My initial impression is that what you are trying to do is very complex. There are utilities such as Rick Fisher's Find and Replace that do that very thing and have been carefully tested, so why would you want to build a system to do that?
    Wendell

Posting Permissions

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