Re: FileMaker Import Excel Files Question
Re: FileMaker Import Excel Files Question
- Subject: Re: FileMaker Import Excel Files Question
- From: Peter Baxter <email@hidden>
- Date: Thu, 6 Dec 2007 06:06:43 +1100
Hi Oakley,
Here is my first shot that works:
tell application "Finder"
set importFolder to (choose folder) as alias
set itemList to the name of every item in importFolder whose name
does not contain "temp1"
end tell
repeat with eachitem in itemList
set myPath to POSIX path of eachitem
set myShellScript to "cp /Users/Yourname/Documents/TestFolder" &
myPath & " /Users/Yourname/Documents/TestFolder/temp1.xls"
do shell script myShellScript
tell application "Microsoft Excel"
activate
activate object worksheet "Selected Items"
end tell
tell application "FileMaker Pro Advanced"
activate
tell layout "Layout #2" of window 1 of document "Temp1.fp7"
do script "Import Documents"
end tell
end tell
end repeat
You will need to tweak this to include your paths to your folders in
the renaming process.
The Filemaker script always imports from the Excel file temp1 and has
no dificulty with finding a range of different files. By the way this
script needs to have only Excel files in that folder.
I appreciate any help here.
Thanks
Oakley
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
Peter Baxter
email@hidden
Music creates order out of chaos: for rhythm imposes unanimity upon
the divergent, melody imposes continuity upon the disjointed, and
harmony imposes compatibility upon the incongruous.
-- Yehudi Menuhin
iChat email@hidden
_______________________________________________
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