software

I have a spreadsheet that is loaded with both data and functions. I
want to save the whole ball-of-wax as a comma-delimited text file that
can be re-imported if necessary at a later date and retain all the data
and math functionality. Where a function is used I want the function
saved to file, not the result value. How do I do that?--
GiggleSwitch
------------------------------------------------------------------------
GiggleSwitch's Profile: www.excelforum.com/member.php...oamp;userid=33115
View this thread: www.excelforum.com/showthread...hreadid=529196Using Find/Replace locate all = signs and replace them all with .=

This will convert all formulae into text strings. Save as .csv When you
later re-import the file, reverse the process and convert all .= into =
--
Gary's Studentquot;GiggleSwitchquot; wrote:

gt;
gt; I have a spreadsheet that is loaded with both data and functions. I
gt; want to save the whole ball-of-wax as a comma-delimited text file that
gt; can be re-imported if necessary at a later date and retain all the data
gt; and math functionality. Where a function is used I want the function
gt; saved to file, not the result value. How do I do that?
gt;
gt;
gt; --
gt; GiggleSwitch
gt; ------------------------------------------------------------------------
gt; GiggleSwitch's Profile: www.excelforum.com/member.php...oamp;userid=33115
gt; View this thread: www.excelforum.com/showthread...hreadid=529196
gt;
gt;


That's a neat trick - Wow! Thanks.--
GiggleSwitch
------------------------------------------------------------------------
GiggleSwitch's Profile: www.excelforum.com/member.php...oamp;userid=33115
View this thread: www.excelforum.com/showthread...hreadid=529196