Start Updating excel sheet

Updating excel sheet

Are you trying to just e-mail one file out with bug fixes (or whatever) that would update existing local XLS files in the background without any User action?

Best bet would be to have the xls files reference one file that is on the network and is protected so users cant accidentally, or otherwise, change it.

Cheers, Coop" id="ctl00_m_m_i_ctl00_gr_ctl11_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="420695" / Ken, VBA in Access and VBA in Excel code may be different.

Your suggestion of using Class Modules sounds promising.

You may need to change some of your coding to reference the utility workbook but once this is done all you have to do is send out a new copy of the utility workbook and it doesn't affect the main workbooks. HTH Mat together and this will open up the visual basic backend.

Philip Manning Principal Researcher Procter & Gamble Pharmaceuticals Norwich, NY 13815 Ph: 607.335.2558 Fax: 607.335.2019 were its at).

We have written code before that creates and deletes source code for an Access application. Ken" id="ctl00_m_m_i_ctl00_gr_ctl09_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="420559" / Look for the module collection in the application model (I think that is were its at).

Phil: I always knew that it may not be possible, but (nothing personal) I hope you're wrong in this case.