Re: beginner's Excel script (round2)
Re: beginner's Excel script (round2)
- Subject: Re: beginner's Excel script (round2)
- From: Walter Ian Kaye <email@hidden>
- Date: Sat, 27 Mar 2004 15:40:44 -0800
At 03:18p -0500 03/27/2004, Michael Bovee didst inscribe upon an
electronic papyrus:
The goal of my script is to pile into one Excel file many columns of
X,Y numerical data (for later importing into my graphing program) from
a whole bunch of text files that Excel is capable of opening directly.
Sounds to me like the entire process can be done within Excel using
one of its native scripting languages (XLM or VBA; your choice). It
seems rather ridiculous to use an external language when you are
starting and ending inside Excel.
Maybe this would be a lot easier for me if I could make it a more
"hands on" Macintosh-like interactive thing, until I learn more
sophisticated ways. So, is it easy to implement 'prompt boxes' where
the script puts up user input dialog boxes that walk me through my
process? For example, start with 1) a box comes up that says "enter a
name for the Master Excel file you want, and I'll create the worksheet.
Box 2) select the first file you want me to get your X,Y data from,
and I'll paste it into the master list. Box 3) select the next file...
and so on.
You can make custom dialogs in Excel, again using either XLM or VBA.
I am all for AppleScriptability of Excel, but for _this_ project, AS
makes no sense. I strongly recommend you do this in XLM or VBA.
-Walter
who could create XLM dialog boxes without even using Dialog Editor
(well, ten years ago I did that sort of thing...)
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.