Re: Moving data from FM pro to Excel
Re: Moving data from FM pro to Excel
- Subject: Re: Moving data from FM pro to Excel
- From: Anders Monsen <email@hidden>
- Date: Wed, 3 Jan 2001 09:34:45 -0600
Thanks, that works perfectly to move the data to a blank file. How would
you direct the data to a named file? Would it be by adding "to worksheet
"name of worksheet"?
>
tell application "FileMaker Pro"
>
set dn to (get data of cell "DN") of record 1 as text
>
end tell
>
tell application "Microsoft Excel"
>
set Value of Cell "$A$1" to dn
>
end tell
>
>
-- hcir
>
mailto:email@hidden
>
>
>
>
> I am trying to move the contents of a field in FileMaker to a cell in
>
> Excel. This could be a new spreadsheet or an existing one (the latter
>
> would over-write data if the cell had content). I am able to move data
>
> from one filemaker db to another, but can't figure out the correct syntax
>
> for going to Excel. This is what I have for FM, which acts upon new
>
> records, creating the same data to act as a relational link between the
>
> two files.
>
>
>
> set newRecord to create new record in database "X"
>
> set cell "a" of newRecord to cell "a" of current record of database "Y"
>
> as text
>
_______________________________________________
>
applescript-users mailing list
>
email@hidden
>
http://www.lists.apple.com/mailman/listinfo/applescript-users