Hi. I think this is possible, but I don't know how to go about it or where
exactly to look.

I have a multi-worksheet workbook that is around 2.4 mb in size. The user
inputs a relatively small amount of information on a few of the worksheets.
The rest of the worksheets hold fixed data used for performing various
calculations or building reports. For each separate use, the user is
performing a 'Save As'. I have one user who is creating up to 20 of these
files each day which is really filling up their hard-drive.

I'd like to have a solution to this problem and I'm guessing that if all of
the 'input' cells were to be exported to a comma delimited text file, the
text file would be very small in comparison. Likewise, if the text file were
imported, all of the calculations and print functions would still work
normally.

So, my question is: How do I go about this?

I'm sure the solution is VBA, but my VBA knowledge is very slim.

Any and all help is much appreciated. TIA :-)

--
rpw