• 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: Excel 2004 issue
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel 2004 issue


  • Subject: Re: Excel 2004 issue
  • From: Paul Berkowitz <email@hidden>
  • Date: Thu, 17 Dec 2009 09:11:27 -0800
  • Thread-topic: Excel 2004 issue

Title: Re: Excel 2004 issue
There were bugs in 2004 that were fixed in 2008. This may be one of those.

Isn't it good they fix bugs sometimes?

Is there any workaround using 'value' instead of 'formula'? (I no longer have 2004.) It should work the same.

However, note you have an error in that script - it shouldn't work in Excel 2008 either (and doesn't here). Between the C:C600 and A2 you have a semicolon (;) - it should be a comma (,). Perhaps the problem is simply that when Excel 2008 you typed the script correctly and when using 2004 you didn't?

--
Paul Berkowitz



From: Jan Bultereys <email@hidden>
Date: Thu, 17 Dec 2009 14:33:04 +0100
To: AppleScript-Users <email@hidden>
Subject: Excel 2004 issue

Does anyone knows why this works in Excel 2008 and not in Excel 2004 (version 11.5.5)

tell application "Microsoft Excel"
    tell active sheet of active workbook
       set inputFormula to "=COUNTIF(C8:C600;A2)"
        set formula of cell "D2" to inputFormula
   end tell
end
tell

I don’t get an error, the formula just doesn’t get placed in the cell.

Other formulas eg.
=COUNT(C8:C600) seems to work without any problem

Many thanks for any feedback
Jan



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

  • Follow-Ups:
    • Re: Excel 2004 issue
      • From: Jan Bultereys <email@hidden>
References: 
 >Excel 2004 issue (From: Jan Bultereys <email@hidden>)

  • Prev by Date: Re: (no subject)
  • Next by Date: Re: (no subject)
  • Previous by thread: Excel 2004 issue
  • Next by thread: Re: Excel 2004 issue
  • Index(es):
    • Date
    • Thread