Update VBA Module Code
 

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

Update VBA Module Code
 

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)

"Todd Huttenstine" wrote in message
...
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