Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
- Subject: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
- From: "koenig.yvan" <email@hidden>
- Date: Wed, 19 Mar 2014 13:51:22 +0100
Problem is when I pull out the tell Excel code into new handler, i.e. on paste_cells_into_Excel_and_Process(cellText, rowCounter) tell application "Microsoft Excel" tell database_workbook activate tell from_website_sheet tell range ("A1:A50") set value to cellText -- delay 1 end tell -- set value of range "A52" to first_name set results_row to value of range "A52:AZ52" set the value of range ("A" & (rowCounter) & ":AZ" & (rowCounter)) to results_row end tell end tell end tell end paste_cells_into_Excel_and_Process
Is the posted script complete ? I ask that because with what you posted I don't see how the handler may know the meaning of :
Of course, if you defined them as properties there is no problem but the instructions doing that are unavailable.
If you didn't,
I think that it would be useful to edit two instructions this way :
my paste_cells_into_Excel_and_Process(cellText, 50 + i, database_workbook, from_website_sheet)
on paste_cells_into_Excel_and_Process(cellText, rowCounter, database_workbook, from_website_sheet)
Yvan KOENIG (VALLAURIS, France) mercredi 19 mars 2014 13:51:15
|
_______________________________________________
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