Apple

Le 21/08/2013 à 17:27, Bruce Robertson <email@hidden> a écrit :

On Aug 21, 2013, at 8:04 AM, koenig.yvan wrote:

is behaving flawlessly.
This code is based upon what was already posted here and what I read in Excel2004 AppleScript Ref.pdf

The problem is that I can't test it.

Then why are you involved with this project?

Bruce Robertson

As I wrote in my first message, I was asked to build a script extracting such datas and using them to edit some folders.

As I don't own/use Merdosoft products I built the script starting from a Numbers spreadsheet.

But my hate of merdosoft product is my problem, not the one of the original asker so I'm trying to build a script fitting exactly all his needs.

I discovered a typo in the script which I asked upon.

I missed a letter "s"

It would be:

# these two instructions aren't speaking to Excel so there is no need to put them in the tell block
set testFile to choose file "PLease select the Excel Workbook!"
set fileName to testFile as string
tell application "Microsoft Excel"
	set newWorkbook to open workbook workbook file name fileName
	tell sheet 1 of newWorkbook
		# the cell B1 is supposed to be empty
		set theRange to (column differences range ("A:A") comparison range "B1")
		set theResult to (value of theRange)
	end tell
end tell

KOENIG Yvan (VALLAURIS, France) mercredi 21 août 2013 17:41:17

References:
	>Re: AS and Excel (From: "Willard L. McMunn" <email@hidden>)
	>Re: AS and Excel (From: "koenig.yvan" <email@hidden>)
	>Re: AS and Excel (From: Bruce Robertson <email@hidden>)