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 |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com