Apple script

Discussion in 'Mac Programming' started by Erin23, Aug 4, 2008.

  1. Erin23 macrumors newbie

    Joined:
    Aug 4, 2008
    #1
    Hi guys,

    I need help with using apple script and excel. I have an excel sheet in which im using goal seek but the problem is that i have up to 60 items to goal seek. I know using apple script would be faster than doing it individually. I have written this code so far but it dosen't seem to work and i was wondering what the problem is and how can I tell apple script to do it 60 times. Thanks

    goalseek (range "Totalvolume" of worksheet "fracture design1)" goal range "F18"
    changing cell (range "fracture length (ft)" of worksheet "fracture design1")
     
  2. tedsmith3rd macrumors member

    Joined:
    Aug 30, 2006
    Location:
    US
    #2
    Can you attach an example of the type of spreadsheet you're referring to? Instead of using applescript can you make this work with excel formulas and maybe filling down/up/whatever? Which version of excel are you using?
     

Share This Page