View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Update a workbook from a script

Hi all,

I have a client that uses Excel workbooks to gather data. Anytime logic
changes within the workbook, the workbook must be redeployed and is
then assumed to be used by the interested parties. This is not strictly
enforced. What I would like to do is, instead of having to redeploy a
workbook when minor logic changes are made to formulas, create a script
that corrects the formulas that are failing. I was thinking of doing
this as an Excel Add-In, but the issue is that the people using the
workbooks are not Excel savvy enough to install and run an Add-In. The
client also would not allow an executable to be deployed to everyone,
so .NET is out. Any suggestions on how I could approach this?

Regards,
Erich