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?

Change the code in another worksheet
 

hi
See this site on how to do the fix.
http://cpearson.com/excel/vbe.htm

regards
FSt1

"keri" wrote:

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?

Change the code in another worksheet
 

If you password protected the code in that workbook, it will be very close to
impossible to use that approach.

--
Regards,
Tom Ogilvy


"FSt1" wrote:

hi
See this site on how to do the fix.
http://cpearson.com/excel/vbe.htm

regards
FSt1

"keri" wrote:

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?