I think this is supposed to open Excel, but I have found the script only works if Excel is already open with a new document. Maybe that gallery screen gets in the way?
Someone else has used bits of one of my scripts in there, Yes, you’re right – either just turn off the the Project Gallery (very easy, the next time it comes up just check to box not to show it), or cut out that Activate as a first step. Instead of:
tell application "Microsoft Excel"
Activate
end tell
tell application "Microsoft Excel" to set FormulaR1C1 of Range "a1:g1" to {"Start", "End", "Duration", "Subject", "Description", "Category", "Location"}
do this:
tell application "Microsoft Excel"
Create New Workbook
Activate
set FormulaR1C1 of Range "a1:g1" to {"Start", "End", "Duration", "Subject", "Description", "Category", "Location"}
end tell
--
Paul Berkowitz
