• 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
GUI possibilities
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

GUI possibilities

  • Subject: GUI possibilities
  • From: Willem <email@hidden>
  • Date: Wed, 30 Apr 2008 10:36:54 +1000
Answering my own question earlier, I found a way to import all my Excel graphs into Filemaker Pro,
by using GUI Scripting (System Events) as described on: http://www.apple.com/applescript/uiscripting/:

tell application "Finder" --- MAKE SURE THAT relevant "Excel" and "Filemaker Pro" files ARE OPEN,
activate                        ---  THAT "Filemaker Pro" IS IN BROWSE MODE and its FV CONTAINER is ACTIVATED!!!
activate document file "CVF.xls" of folder "Desktop" of folder "myData" of folder "Users" of startup disk
select window of desktop
tell application "Microsoft Excel" --- 
run VB macro "CopyChart"
delay 2
end tell
activate document file "NHdata.fp7" of folder "Desktop" of folder "myData" of folder "Users" of startup disk
select window of desktop
try
tell application "FileMaker Pro"
activate
end tell
tell application "System Events"
tell process "FileMaker Pro" --- in Browse mode !!!
tell menu bar 1
tell menu bar item "Edit"
tell menu "Edit"
click menu item "Paste"
delay 2
end tell
end tell
end tell
end tell
end tell
return true
on error error_message
return false
end try
end tell

It works on Mac OS X v10.5 too !!
Sorry to bother you folks.

Willem.
 _______________________________________________
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
  • Prev by Date: Re: View Options
  • Next by Date: Record/List Coercion
  • Previous by thread: Summary: choose from list re-visited - again
  • Next by thread: Record/List Coercion
  • Index(es):
    • Date
    • Thread