Hi all!

I've got a bit of a problem (duh! why else would I be posting here?
lol)

Anyways, I have created an extensive price list database and quotation
template along with a 47 page user manual and a profitability
estimation. All the files reside in their respective folders as part of
my 'Quotation System'. Every time I forward the updates of this
Quotation System to the end users via E-mail, I first create a normal
Winrar self-extracting archive.

As and when the end-users extract the rar file (.exe), all the files in
the destination folder are replaced (overridden) with the newer files
(upon them choosing "Yes to all". This acts as crude yet relatively
efficient updating method.

My problem is that I would like the values of certain cells to be
retained and not overridden by the newer updated files.

Please bear in mind that I will need to keep my workbook protected, as
well as the sheets as they currently are. Also, I would like not having
to resort to using a macro (activated by the end-user) to copy the
contents of one file to the other.

IS THERE A WAY TO DO THIS DURING THE PROCESS OF FILES BEING COPIED AND
REPLACED VIA THE SELF-EXTRACTING RAR ARCHIVE? OR DO I HAVE TO USE A
MACRO? IF NO OTHER OPTION EXISTS BUT USING A MACRO THEN A SKELETON MACRO
TEMPLATE OF WHICH I ONLY NEED TO FILL IN THE CELL REFERENCES WILL HELP
TREMENDOUSLY!


--
ARbitOUR
------------------------------------------------------------------------
ARbitOUR's Profile: http://www.thecodecage.com/forumz/member.php?userid=254
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=89788