Re: Excel and Filemaker pro 12
Re: Excel and Filemaker pro 12
- Subject: Re: Excel and Filemaker pro 12
- From: waynemelrose <email@hidden>
- Date: Fri, 15 Mar 2013 08:23:51 +1100
On 15/03/2013, at 7:48 AM, Robert Cuilla < email@hidden> wrote: Hello to all,
I have been away from AS for sometime and have a problem task I would like to script. Perhaps some can give me some guidance or direction.
I have an Excel file from which I would like to choose selected cells, open an existing Filemaker file, create a new record and then put the selected Excel cells into the appropriate fields
If I where to say it in different words I would say
1. Open Filemaker file "abc.fmp12".
2. Create new record in Filemaker file "abc.fmp12".
3. Open Excel file "excel1.xlxs".
4. Take cell A4 from file "excel1.xlxs" and place in field "name" in Filemaker file "abc.fmp12".
Thank you in advance for any reference, or guidance
Bob
I havne't gone right into how you would open each of the documents, but I imagine for transferring information between the two programs you'd have the file/db's launched already… This should get you started.
tell application "Microsoft Excel" set ExcelCellValue to value of cell "A4" end tell
tell application "FileMaker Pro" tell database "abc.fmp12" tell front window create new record go to last record tell current record set cell "name" to ExcelCellValue end tell end tell end tell end tell
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden