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

Best way would be to create an Excel add-in, and distribute that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Revolvr" wrote in message
news:LFimc.12076$k24.10212@fed1read01...

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

I have module manipulation examples on my website.
I believe one of these examples does a search/replace and another does
imports to workbooks.

If you need something specific, let me know.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Revolvr" wrote in message
news:LFimc.12076$k24.10212@fed1read01...

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