Saving just one of the worksheets to a disket

[Zainuddin Zakaria]

Hi all,

I have an Excel file (workbook) that contains several worksheet. Is there
any macro command that I can use to allow users to just save (save as) one
of the worksheet (say WorksheetA) to a disket in
1) Floppy Disk A
2) Hard Disk C
3) USB drive (thumbdrive)

Thanks.

Zainuddin Z

 

[David McRitchie]

First of all never save directly to a diskette from Excel
nor read directly from a diskette to Excel.
http://www.mvps.org/dmcritchie/excel/backup.htm

Edit, move or copy sheet, near the top select
(new workbook), and at the bottom be sure to
check "make a copy" make the copy to your
hard drive.

Check that your worksheet still shows all of the
values.

If you just want values, and not formulas you can
on your new workbook with the one sheet,
select all cells (before Excel 2003 that was Ctrl+A)
then Copy (Ctrl+C) then Edit, Paste Special, Values.
Then delete the other sheets

Close the file in Excel and then copy the prepared
file from your hard drive to the diskette.

 

[David McRitchie]

I missed a couple of items.
The not using a diskette directly with Excel, actually
applies to any portable device. The problems
1) Excel must be able to have the space for at LEAST
as much space as the original workbook.
2) Portable media may be inadvertently taken offline
and not be closed.

You can record a macro from the directions previously
provided. Use "cells." instead of "selection."
in the final macro to involve all cells.