Excel search and hyperlinks

Scripting Forums AppleScript | Mac OS X
#1

Hi MacScripter,

I need to makes inquiries from address book into Microsoft Excel. When I have established the person exists in my address book I want to check a .xls document and the send some data to the member.

For example: my database would look like this:-

Monday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers

Tuesday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers

Wednesday
07:00
Abbott
www.internet.com/abbott
10:00
Costello
www.internet.com/Costello
12:45
Hancock
www.internet.com/Hancock
13:00
Sellers
www.internet.com/Sellers

For example: the data I send to address book is:-

marx@email.net, Database1, Monday, 9.43

at that time the answer would be:-

Abbott
www.internet.com/abbott

I could then send that to marx@email.net

How would I get the URL if it is a hyperlink in Excel and not a separate field?

I hope you can help me with some of this. I was quite successful getting applescript to manipulate Address Book. But Excel looks daunting!

Reagrds drPETE

#2

Excel is daunting. What version are you using - X and 2004 are quite different from a scripter’s point of view.

#3

Hi Adam,

Excel 2004 for Mac version 11

Do I actually have to integrate Address Book? Can I have another part of the database with the users names and email addresses?

Regards Pete

#4

I can’t answer, Pete;

I’m still using Excel X.

Adam

#5

My Excel 2004 now looks like this:-

Monday Tuesday Wednesday MEMBER EMAIL
07:00 07:00 07:00 Marx Brothers marx@skipzone.co.uk
Abbott Abbott Abbott Russ Abbott Abbott@skipzone.co.uk
www./abbott www./abbott www./abbott Lou Costello costello@skipzone.co.uk>
10:00 10:00 10:00 Tony Hancock hancock@skipzone.co.uk>
Costello Costello Costello Peter Sellers sellers@skipzone.co.uk>
www./Costello www./Costello www./Costello Charlie Chaplin chaplin@skipzone.co.uk>
12:45 12:45 12:45 Buster Keaton keaton@skipzone.co.uk>
Hancock Hancock Hancock Whoopi Goldberg goldberg@skipzone.co.uk>
www./Hancock www./Hancock www./Hancock Peter Cook cook@skipzone.co.uk>
13:00 13:00 13:00 Tommy Cooper cooper@skipzone.co.uk>
Sellers Sellers Sellers
www./Sellers www./Sellers www./Sellers

So for example:- When I get an email at 9.53 Tuesday with subject ‘Lou Costello’ a mail rule triggers applescript to open desktop havingalaugh.xls find the email address for the sender and then perform a day/time query to find the ‘show’ and associated URL then send result to the new mail address.

I am going to make a start with the easy bits. Please Help!