Update VBA Module Code

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey is there anyway to make an executable file or some
other sort of file that can update code within certain
modules?

There may be some code later on down the road that I would
need to update and would like to be able for users to just
click a file and it update their existing file rather than
having to re-distribute another spreadsheet with the
updates contained in it.


Thank you.
Todd Huttenstine
 
Todd,

If you mean that you would like to add code to an existing code module on
the fly, the answer is yes, it can be done, but it is not trivial. Chip
Pearson has a good web page explaining the techniques at
http://www.cpearson.com/excel/vbe.htm

--

HTH

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