View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keri keri is offline
external usenet poster
 
Posts: 34
Default Change the code in another worksheet

Hi,

I have made a spreadsheet that has been distributed to 100 + people. I
have noticed an error in the code. Instead of re-distributing the
spreadsheet to everybody I want to send out a "program" that will
change the error.

Here's how I imagine it working;

User is e-mailed a spreadhseet "Fix"
User opens spreadsheet "Fix" and clicks button
Button calls code which opens a select file dialog box for the user to
select the "original" file
Code then opens the "original file" finds the incorrect code, changes
it and saves the file
Code closes the "Fix" and deletes it from the system

I have a feeling this "may" be possible but could also be problematic.
However this is the only way I can think of without re-distributing
new spreadsheets which is a massive task. Seeing as I wrote the code
in the first one will this work?