Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!ucsd!ucbvax!agate!shelby!csli!ramaley From: ramaley@csli.Stanford.EDU (Alan Ramaley) Newsgroups: comp.sys.mac.apps Subject: Re: wanted Excel macro code Message-ID: <17499@csli.Stanford.EDU> Date: 29 Jan 91 02:57:43 GMT References: <1991Jan28.225508.983@massey.ac.nz> Organization: Center for the Study of Language and Information, Stanford U. Lines: 18 In <1991Jan28.225508.983@massey.ac.nz> R.Singh@massey.ac.nz (R. Singh) writes: >I'm attemting to write macros which non-interactively extract data and create >graphs. >Thanx >Raminder $ingh Phone : +64 63 69 099 X 7772 The best way to learn macros is to use the 'record' option, fool around, and then 'stop recording' and look at the sheet. Also, look under the excel help function for 'Text' or 'String' function. These should be helpful. The hardest part of writing macros to process strings is writing the cell formulas. --Alan -- --Alan