Copying VBA modules from one workbook to another with a macro?

R

Revolvr

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
 
B

Bob Phillips

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)
 
R

Rob van Gelder

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data from one workbook to another one using VBA 0
Check to see if a Workbook has a Macro 4
Can I password protect VBA modules using a macro? 2
Hide VBProject while copying Forms & Modules to another workbook 3
Create a workbook with macros from inside another macro 1
Extracting (copying) modules from one workbook to another. 1
Open Workbook Macro - with a twist 1
Copy Modules from One workbook to Active Workbook 1

Top