Exporting Excel spreadsheets with functions
 

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: http://www.excelforum.com/member.php...o&userid=33115
View this thread: http://www.excelforum.com/showthread...hreadid=529196

Exporting Excel spreadsheets with functions
 

Using 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 Student


"GiggleSwitch" wrote:


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: http://www.excelforum.com/member.php...o&userid=33115
View this thread: http://www.excelforum.com/showthread...hreadid=529196

Exporting Excel spreadsheets with functions
 

That's a neat trick - Wow! Thanks.


--
GiggleSwitch
------------------------------------------------------------------------
GiggleSwitch's Profile: http://www.excelforum.com/member.php...o&userid=33115
View this thread: http://www.excelforum.com/showthread...hreadid=529196