fix error in multiple vba excel files

[Jshugs]

Hello-

I recently discovered that there is a bug in the vba code of a template excel file that has been copied to over 3000 files. I figured out how to fix the problem, but I would like to update the previous 3000 files that had the bug. Is there any way to do some sort of batch copy and paste of the actual vba code to all of those files?

thanks
-Jon

 

[hiker95]

Jshugs,

This may get you started in the right direction:

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx

Introduction
You can write code in VBA that reads or modifies other VBA projects, modules, or procedures. This is called extensibility because extends the editor -- you can used VBA code to create new VBA code. You can use these features to write custom procedures that create, change, or delete VBA modules and code procedures.