LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Links Update TracyB Links and Linking in Excel 0 February 21st 06 01:48 PM
Auto Update of a field referencing to a field in another workbook Camper Joe Excel Worksheet Functions 1 February 14th 06 06:14 PM
inter workbook links do not update even when both are open ??? Lawrenph Excel Discussion (Misc queries) 3 June 3rd 05 02:14 PM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM
formula update in individual cells in a whole workbook QuietRanger Excel Discussion (Misc queries) 3 January 29th 05 03:15 AM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"