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: g3pb <email@hidden>
- Date: Tue, 02 Jan 2001 17:21:10 -0900
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