Saving just one of the worksheets to a disket

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zainuddin Zakaria - 28 Dec 2006 16:22 GMT

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

Reply to this Message

David McRitchie - 30 Dec 2006 00:26 GMT

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Zainuddin Z

Reply to this Message

David McRitchie - 30 Dec 2006 00:51 GMT

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> First of all never save directly to a diskette from Excel
> nor read directly from a diskette to Excel.
[quoted text clipped - 35 lines]
> >
> > Zainuddin Z

Reply to this Message