Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!zaphod.mps.ohio-state.edu!mips!apple!agate!stanford.edu!csli!ramaley From: ramaley@csli.Stanford.EDU (Alan Ramaley) Newsgroups: comp.sys.mac.apps Subject: does excel know the name of an inserted disk? Message-ID: <18686@csli.Stanford.EDU> Date: 15 Apr 91 17:56:55 GMT Organization: Center for the Study of Language and Information, Stanford U. Lines: 22 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