[Pythonmac-SIG] appscript and Office 2011, not working?

has hengist.podd at virgin.net
Thu Feb 17 13:34:02 CET 2011


Christian Prinoth wrote:

> My problem is that this way I can only reference a range in the currently active worksheet.
> Using standard appscript syntax I would do the following:
>
> app('Microsoft Excel').worksheets['Sheet1'].ranges['A1'].value()
>
> to access data on a specific cell on a specific worksheet. How do I do that
> with the AEM syntax you suggested?

	excel = app('Microsoft Excel')
	ws = excel.worksheets['Sheet1']
	excel.AS_newreference(ws.AS_aemreference.elements('X117'))[address]

HTH

has


More information about the Pythonmac-SIG mailing list