Copy field to Office App

[Jon Crain]

I'm trying to export a couple of fields into Powerpoint, but I cannot get the applescript correct. Running a native applescript will allow me to put something into Powerpoint, but I can't get a field to export and then show up in Powerpoint.

I've tried writing a calculated script, but I always seem to get an error 2741, so I must have something wrong.

Here is the calculated script I'm using any help would be appreciated.

"tell application "Microsoft PowerPoint"

activate

set this_presentation to make new presentation

set this_slide to make new slide at the beginning of this_presentation ¬

with properties {layout:slide layout title slide}

set the title_text to text range of text frame of shape 1 of this_slide

set the subtitle_text to text range of text frame of shape 2 of this_slide

set content of the title_text to "" & Event_Select::Title & ""

set content of the subtitle_text to "" & Event_Select::Description & ""

end tell"

jon

[bruceR]

You're giving FileMaker instructions to Powerpoint. That really cannot be expected to work. Try something like this. And don't use the calculated applescript, use native applescript

copy cell "Event_Select::Description" of current record to Description

copy cell "Event_Select::Title" of current record to Title

tell application "Microsoft PowerPoint"

activate

set this_presentation to make new presentation

set this_slide to make new slide at the beginning of this_presentation ¬

with properties {layout:slide layout title slide}

set the title_text to text range of text frame of shape 1 of this_slide

set the subtitle_text to text range of text frame of shape 2 of this_slide

set content of the title_text to Description

set content of the subtitle_text to Title

end tell

Edited November 30, 2006 by Guest

[Jon Crain]

I came back to the forum to see if there were any more attempts at what I was doing here, and realized that I had actually posted something, so I thought I would update to what I found out. I ended up using a calculated applescript to do this, check it out...(I think I was missing the "¶" the first time.

"tell application "Microsoft PowerPoint"¶

activate¶

set this_slide to make new slide at the end of the active presentation ¦

with properties {layout:slide layout title slide}¶

set the title_text to text range of text frame of shape 1 of this_slide ¶

set the subtitle_text to text range of text frame of shape 2 of this_slide ¶

set content of the title_text to "" & Event_Select::Title & "" ¶

set content of the subtitle_text to "" & Event_Select::Attendee & "" ¶

set content of the subtitle_text to "" & Event_Select::Description & "" ¶

set font name of font of title_text to "Optima"¶

set font name of font of subtitle_text to "Optima"¶

set font size of font of title_text to 24.0¶

set font size of font of subtitle_text to 18.0¶

end tell"