• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: AS and Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AS and Excel


  • Subject: Re: AS and Excel
  • From: "koenig.yvan" <email@hidden>
  • Date: Wed, 21 Aug 2013 17:42:13 +0200


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



 _______________________________________________
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

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>)

  • Prev by Date: Re: AS and Excel
  • Next by Date: Re: AS and Excel
  • Previous by thread: Re: AS and Excel
  • Next by thread: Re: AS and Excel
  • Index(es):
    • Date
    • Thread