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

Excel question


  • Subject: Excel question
  • From: Antonio Palluan <email@hidden>
  • Date: Sat, 1 Apr 2006 18:50:54 +0200


Hi everybody, I'm Antonio and I'm new in this list, nice to meet you all! 
I'm an absolute beginner with applescript but I find it very attractive and I think I'll spend lot of time studying it... I'm descovering the potential...

So, maybe some times I'll ask you some suggestions  ...  Like this.. :-)

I've got an excel file with a list of numbers and names in the cells. For example:

           A               B
1    ELEN 12580
2 MARK 12568
3 PHIL 45622

In excel I want to find for example the cell Phil and read the number that is on the right of it...

Well.. very simple... It's two days that I'm trying to do that!!! :-(

tell application "Microsoft Excel"
set marc to find range "$a:$a" what "mark"
set row to get first row index of mark
set targetcell to "[Fattdettagl.xls]Foglio1!$B$" & row
....
end tell

well I'm not able to receive a target cell with the right range...

How would you do it??

Be patient, probably it is a stupid question but... be comprehensive :-)

Thank you

--

Antonio
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Excel question
      • From: Paul Berkowitz <email@hidden>
  • Prev by Date: Re: Quicktime - export audio
  • Next by Date: Re: With Transaction in FileMaker Pro
  • Previous by thread: Re: Quicktime - export audio
  • Next by thread: Re: Excel question
  • Index(es):
    • Date
    • Thread