Re: Scripting copy and paste commands in FileMaker
Re: Scripting copy and paste commands in FileMaker
- Subject: Re: Scripting copy and paste commands in FileMaker
- From: Courtney Moore <email@hidden>
- Date: Fri, 15 Aug 2003 13:23:10 -0500
It almost works. Except for some reason when copying the data from the
field it also grabs other data from the layout ...argg...
The syntax I am using it as follows:
Tell appilciation "FileMaker Pro"
Set textcopied to cell "z_yearMonthSpreadsheet" of database "Hours_.FP5"
End tell
Tell application "Finder"
Set clipboard to textcopied
End tell
Tell application "Microsoft Word"
Tell document 1
Paste
End tell
On 8/14/03 5:49 PM, "Kelvin Aitken" <email@hidden> wrote:
>
Tell application "FileMaker Pro"
>
set myText to cell "z _yearMonthSpreadsheet" of record 1 of document
>
"whateverYourDatabaseIsCalled"
>
set the clipboard to myText
>
end tell
>
>
Make sure your database is open first. It will work faster if you skip
>
the "activate" command. You may need to "tell document 1" in Word to paste.
>
>
Kelvin.
>
>
>
>
>
>
> On Thursday, August 14, 2003, at 04:06 PM, Courtney Moore wrote:
>
>
>
>> Hello Everybody-
>
>> I have again stumbled across another road block.
>
>> I am trying to copy data from a from a field in FileMaker and then
>
>> pasting
>
>> that data into Word document. No syntax I use seems to work.
>
>>
>
>> Here is a failed script attempt of the things I
>
>> Tell application "FileMaker Pro"
>
>> Activate
>
>> Select (data of cell "z _yearMonthSpreadsheet")
>
>> Copy
>
>> End tell
>
>> Tell application "Microsoft Word"
>
>> Paste
>
>> End tell
>
>>
>
>> Apparently FileMaker does not understand the select command.
>
>> Does anyone have anyother suggestions?
>
>> Thanks For Your help!
>
>>
>
>> Courtney
>
_______________________________________________
>
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.
_______________________________________________
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.