View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Revolvr[_2_] Revolvr[_2_] is offline
external usenet poster
 
Posts: 9
Default Copying VBA modules from one workbook to another with a macro?


I have created an Excel workbook tool that has a fair amount of VBA code in
several modules. This tool was distributed to a number of users.

If we were to discover a defect in the workbook - highly unlikely of course!
Or if I want to add new features, I would like to be able to update
everyone's workbook automatically by using a macro, opening the files and
replacing the modules with new modules. The alternative is to manually
update each workbook instance.

Is this possible?

Thanks,

-- Rev