ramaley@csli.Stanford.EDU (Alan Ramaley) (04/16/91)
Hey folks. A little excel quiz for you.
(1) Is there a way, in excel, to tell what the name of the disk in an
internal drive is? In a macro I'm writing, I ask the user, 'please
insert a disk so I can do a back-up', but then I need to call up
SAVE.AS?(), and they have to click on drive, and yes, they want to
replace the old one, and so on. I want to be able to figure out the
path to the disk, for any given disk, with any number of hard-drive
partitions, so I can make all of this invisible to the user.
(2) Also, is there a way to specify the format of a document without
saving it? That is, can I designate 'Untitled1' as format 'text',
instead of 'normal', when I open it? Otherwise I'd need to do a
SAVE.AS("fakename",3). I want the document to be unsaved but text.
So, set me up.
--
Alan Aitken Ramaley
(415) 497-5265, P. O. Box 9217, Stanford, CA 94309
Senior, Symbolic Systems
Aquarius