Excel Annoyance: No Save a Copy as... functionality

[David R. Waddell]

Hi Marsee,
I belong to the:

Pikes Peak Perl Mongers <pikes-peak-pm-list at happyfunball.pm.org>
all the best,
david
At 16:44 2/6/2004, Marsee Henon wrote:
>Hi David,
>
>Thanks for passing this along. What user group do you belongto ? I want to 
>make
>sure I send them a book when it is available.
>
>--marsee
>
>
>At 03:16 PM 2/6/2004 -0700, you wrote:
>>Hi Marsee,
>>I have a whole bunch of them. Here is one for which there is
>>only an awkward work-around for us:
>>
>>We need to save a copy of our sheets in tab-delimited format for
>>a script to run on the data in the sheets. Ideally, one would
>>just choose a menu command Save Copy As ... which would leave the
>>format of the workbook on the screen in Excel format. It is possible to write
>>a macro and assign it to menu. However, macros of this sort fail
>>on Workbooks in Excel97 or later. Since we need DataValidation functionality
>>we cannot use Excel95 format for the spreadsheets.
>>
>>I've reported the problems with macros to Microsoft several years ago. 
>>They never reply or attempt to fix the problem.
>>
>>...so
>>Every time we want to save a copy in tab-delimited format we must use
>>Save As and then go through a bunch of silly dialogs about whether you
>>really want to save in this format, and eventually save the spreadsheet
>>a second time in Excel format to get back to the Workbook format.
>>
>>As soon as OpenOffice's spreadsheet has pop-down lists for choosing
>>values for a cell, we will move to it.
>>
>>Excel97/Excel2000 under Win98 or Win2000
>
>
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>Marsee Henon
>O'Reilly & Associates
>1005 Gravenstein Highway North  Sebastopol,   CA   95472
>707-827-7103     800-998-9938     Fax 707-829-0104
>marsee at oreilly.com
>http://ug.oreilly.com/  http://www.oreilly.com/ 
>http://conferences.oreilly.com/
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~