Categories: Misc / DotNet / Java / Coder / Linux / PHP Ask - La ask - La Answer

help modifying itunes to appleworks script, probably a completely stupid questio

hi this is my first attempt at scripting, i'm a quick learner, but after deliberating this for some time i finally have to ask for some help.
i am trying to change the itunes to appleworks script so that the playlist will export to a new EXCEL document instead of an appleworks spreadsheet.
my problem is this:

tell application "Microsoft Excel"
make new spreadsheet at front with properties {Name:"Summary of " & List_to_summarise, spreadsheet:"paul"}
set parts to 1 -- this is how many spreadsheats excel has created during this script..limit of 500 rows on creation
end tell

when i run the script it says 'error, The variable spreadsheet is not defined.'

i've looked in the excel dictionary and i can't find how to define a spreadsheet. or whatever.
some help would be appreciated because this has been driving me NUTS.
thanks in advance!
[923 byte] By [_xfire] at [2007-11-9 20:23:57]
# 1 Re: help modifying itunes to appleworks script, probably a completely stupid questio
Excel's dictionary is pretty thorough. It doesn't list spreadsheet as an object anywhere I could find, which explains why "spreadsheet" is being interpretted as a variable that has not been defined.

This worked to create a new spreadsheet:

tell application "Microsoft Excel"
Create New Workbook
end tell
As for columns and such, you'll have to do your own exploring. Use the "Record" function of Script Editor to gain some insight.

Good Luck!
Doug Adams at 2007-11-15 17:24:56 >
[an error occurred while processing this directive]
[an error occurred while processing this directive]