• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: FileMaker Import Excel Files Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >FileMaker Import Excel Files Question (From: Oakley Masten <email@hidden>)

  • Prev by Date: Re: What makes AppleScript difficult
  • Next by Date: Spell checking in Applescript
  • Previous by thread: Re: FileMaker Import Excel Files Question
  • Next by thread: Re: FileMaker Import Excel Files Question
  • Index(es):
    • Date
    • Thread