+ Reply to Thread
Results 1 to 2 of 2

Editing VBA code in other workbooks using VBA code

  1. #1
    Registered User
    Join Date
    09-24-2017
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    15

    Editing VBA code in other workbooks using VBA code

    Hi,

    I'm looking to essentially find and replace some text in VBA codes in various workbooks. My intention was to move all the workbooks to a certain folder, then have an editing code which basically says:
    - for each workbook in folder XXX
    - for each element of code in each workbook
    - find "123" and replace with "ABC"

    I've never done anything involving changing VBA code using VBA code, but I assume it's possible as I've googled some terms but can't make sense of it.

    I'd appreciate any help/guidance!

  2. #2
    Registered User
    Join Date
    10-15-2013
    Location
    Hawaii
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Editing VBA code in other workbooks using VBA code

    http://www.cpearson.com/excel/vbe.aspx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help editing VBA code
    By wonderd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2016, 07:26 PM
  2. Replies: 0
    Last Post: 05-06-2013, 05:45 AM
  3. Help:in editing code
    By opd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 02:38 AM
  4. Help Editing Code That Copies Worksheets to New Workbooks
    By Panda2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2012, 12:23 PM
  5. Self editing code..?
    By Arne Hegefors in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2006, 11:05 AM
  6. Editing VB Code with VB
    By Simon Shaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2005, 03:05 PM
  7. stubborn Excel crash when editing code with code, one solution
    By Brian Murphy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2005, 02:06 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