Macintosh Laptops

Seeking a good reference/tutorial for AppleScript.?

I have a MacBook with OS 10.5 and Office 2005.

The ultimate goal is to take data from an Excel spreadsheet and have it put into a website's text field(s). (I'm using Safari).

I can handle the VBA part of it, but getting from the Clipboard to Safari is outside of Excel VBA.

I'm hoping to use AppleScript to do this. I've had limited success combining Animator and Script Editor, but a book or tutorial on Apple Script would get me there faster (and with better script.)

A help forum dedicated to Apple Script would also be useful.

Thanks in advance.
Thanks OpenSource,
The getting data into the Clipboard is no problem. VBA's DataObject.
I already have is Excel>Clipboard. I want to replace my manual "activate Safari" "paste into first box" "activte Excel" "activate Safari" "paste into second box". Your reply suggests that Java is another link in the chain.

I'll check out that book.
Thanks.

AppleScript, unfortunately, probably will not be able to do this, depending on your needs.
If you know the text fields' names for your website, you could try this script:
tell application "Safari"
set the URL of tab 1 of window 1 to "your website's url here"
delay 3
do JavaScript "document.forms[0].name of text field one.value = \"" & "what you want the value to be\"" in document 1
do JavaScript "document.forms[0].name of text field two.value = \"" & "what you want the value to be\"" in document 1
do JavaScript "document.forms[0].submit()" in document 1
end tell
However, this will not do any automation outside what you put in the value spots (basically, it won't connect to the Clipboard and you'll have to insert the text box values manually). So:
You could try to go to this website:

http://www.apple.com/applescript/

but it is sort of hard to navigate to the full instructions. There are several books out there, I would get "AppleScript: The Definitive Guide" by Matt Neuburg and O'Reilly Media.
The problem is, I'm not sure if Office has any AppleScript bridges that allow the script editor to gain access to the Office clipboard. You could search "Microsoft Office AppleScripts" in google, but you might get already created stuff.
Your best bet is to move the data into a database (preferably MySQL - this is preinstalled on MacOS10.5 - google MySQL for tutorials), and then use a server-side scripting web development framework (Ruby on Rails is preinstalled, google RoR for tutorials, you could also use Django for Python or CakePHP for PHP), to upload the information in the database to your website.

Mac Blog - Giorno 263 - Clips

Kensington 60702 Notebook Expansion Dock with Adjustable Base (PC) $227.50 Universal docking station converts laptops into desktops instantly. Detachable dock provides 5.1 audio, Ethernet, parallel, serial and USB 2.0 connections through a single USB plug. SmartFit system adjusts screen height to optimal ergonomic setting. Compatible with all Windows-based notebooks. For Use With: Notebooks; Operating System Compatibility: Windows; Connector/Port: 5.1 Audio;Ethernet;Para...

TOOL KIT CLIPBOARD $15.99 TOOL KIT CLIPBOARD

Clipboard,Slimmate,Ltr,Be $13.99 CLIPBOARD,SLIMMATE,LTR,BE

Clipboard,Redirite,Memo,Am $24.99 CLIPBOARD,REDIRITE,MEMO,AM

Clipboard,Slimmate,Pk $7.99 CLIPBOARD,SLIMMATE,PK

Clipboard,Letter,6/Pk,Brn $6.99 CLIPBOARD,LETTER,6/PK,BR

Clipboard,Legal,3/Pk,Brn $3.99 CLIPBOARD,LEGAL,3/PK,BR

Clipboard,Recycled,Pk $5.99 CLIPBOARD,RECYCLED,PK

Clipboard,Ltr,Trans,Plstic $14.99 CLIPBOARD,LTR,TRANS,PLSTIC

Aluminum Clipboard $6.99 Aluminum clipboard is an enduring classic. 1/2"-capacity clip. Holds forms up to 8 1/2 x 11. Clipboard Type: Clipboard; Clip Capacity: 1/2 in; Number of Compartments: N/A; Holds Form (height): 11 in.

Sparco Clipboard $2.99 0% 01858 1 Each 6" 6" Width x 9" Length 9" Clipboard provides a stylish and functional way to write without the use of a desk. Sturdy spring clip secures paper and is made of metal. Clipboard is made of durable molded plastic. Clear Clipboard No Plastic Sparco Sparco Products Spring Clip

Saunders Clipboard $8.99 0% 0.13" Thickness x 8.50" Width x 12" Length 0.50" 1 Each 12" 21565 8.50" Acrylic clipboard with strong low profile clip with rubber grips holds up to 1/2" paper securely. Attractive, lightweight, shatter and scratch resistant 1/8" thick clipboard hold letter/A4 size paper. Clipboard includes inch and metric ruler edges and a built-in hanging hole. Acrylic Clear Clipboard Low-profile No Saunders Saunders Mfg. Co. Inc US www.saunders-usa.com

Man Holding Clipboard and Pencil $24.99 Man Holding Clipboard and Pencil - Photographic Print

Molten Clipboard $22.95 The Molten Clipboard is the perfect tool for any coach. It is made of durable plastic and features the Molten logo. The metal clasp holds all of your papers in place.

OIC Clipboard $2.99 0% 1 Each 1" 12.50" 83100 9" 9" Width x 12.50" Length Hardboard clipboard is made from high-quality, brown hardboard and designed for maximum durability. Rust-resistant clamp holds up to 1" of paper securely in place. Clipboard is made from 100 percent recycled or recovered wood material. Brown Clipboard Design for the Environment (DfE) Hardboard Metal Clamp No OIC Officemate International Corp. Yes www.officemate.com

Truck Driver Holding Clipboard $24.99 H. Armstrong Roberts Truck Driver Holding Clipboard - Photographic Print

Hand Holding Clipboard With Blank Paper $24.99 Hand Holding Clipboard With Blank Paper - Photographic Print

Two Men Standing, Looking at Clipboard $24.99 Two Men Standing, Looking at Clipboard - Photographic Print

Sparco Transparent Clipboard $5.99 0% 01866 1 Each 12" 9" 9" Width x 12" Length Clipboard provides a stylish, functional way to write without the use of a desk. The flat clip makes this durable, plastic clipboard space-efficient and easy to use. The imprinted rulers on both sides of the clipboard have measurements in Imperial and metric. Clipboard includes a pullout tab for hanging. Clipboard Low-profile Neon Orange No Plastic Sparco Sparco Products Transparent Clipboard

MMF Wedgy Pen Clipboard $13.99 0% 1 Each 11" 258470004 8.50" 8.50" Width x 11" Length Wedgy Pen Clipboard Clipboard Pen #2 Pencil Clipboard with coil pen includes attached refillable pen. Coil retracts to less than 6". Ideal for registration and sign-in areas. Spring-loaded clip holds Wedgy pen and a No. 2 pencil. Clipboard hangs from hook or nail. Black China Clipboard Low-profile MMF MMF Industries No Plastic Wedgy Pen Clipboard www.mmfind.com

Pendaflex I.Organize Clipboard $2.99 0% 1 Each 10031 11" 30 Sheet 8.50" 8.50" Width x 11" Length Clipboard is designed for use with the Esselte I.Organize System. Use clipboard for note-taking and agendas. Clip slides up to allow more paper and neatly slides back to secure documents to the board. Clipboard is made of durable, water-resistant poly and holds 30 sheets. China Clear Clipboard Esselte Ltd I.Organize I.Organize Clipboard No Pendaflex Poly www.esselte.com

Nurse Assist Clipboard $18.99 "Diagnostic Reference Guide For Nurses And Students. 9""X 12"" Two-Sided Clipboard With An Array Of Diagnostic Referencing Information. Clipboard Also Features A Calculator, Clock, Count Up/down Timer All-In-One. "