Excel Annoyance: No Save a Copy as... functionality
David R. Waddell
dave.waddell at mci.com
Mon Feb 9 10:16:15 CST 2004
I belong to the:
Pikes Peak Perl Mongers <pikes-peak-pm-list at happyfunball.pm.org>
all the best,
At 16:44 2/6/2004, Marsee Henon wrote:
>Thanks for passing this along. What user group do you belongto ? I want to
>sure I send them a book when it is available.
>At 03:16 PM 2/6/2004 -0700, you wrote:
>>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.
>>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
>O'Reilly & Associates
>1005 Gravenstein Highway North Sebastopol, CA 95472
>707-827-7103 800-998-9938 Fax 707-829-0104
>marsee at oreilly.com
More information about the Pikes-peak-pm