How can i get ref. to specified cell of active row (Excel MacOffice)

Scripting Forums AppleScript | Mac OS X
#1

i need to open Indesign document by path, which in cell #5 of row of active cell. How can i get reference to cell 5 of row of active cell?

so far i have:
active cell is first in row.

tell application "Microsoft Excel"
	set cellToPath to get offset active cell column offset 5
	set mPath to value of cellToPath
	display dialog string (mPath)
end tell

But i’d like to get path from cell/column 5 no matter, where active cell is (in active row of course).

Thanks.

#2

Hi,

try this


tell application "Microsoft Excel"
	set currentRow to first row index of selection
	set mPath to value of cell 5 of row currentRow
end tell
#3

Stefan, thanks! that’s i wanted))