Re: Excel 2004 issue
Re: Excel 2004 issue
- Subject: Re: Excel 2004 issue
- From: Jan Bultereys <email@hidden>
- Date: Fri, 18 Dec 2009 10:48:02 +0100
- Thread-topic: Excel 2004 issue
Title: Re: Excel 2004 issue
Hi Paul,
You are right it worked with the comma.... And no I didn’t typed any error... I just copied the code generated from excel (2004-2008) back into the script which is with at semicolon.
So changing the semicolon in a comma worked from the script ...But when I look at the code in Excel it changed back to semicolon.... Really odd.
Anyway you helped me out Paul thanks for the fix!
Kind regards,jan
From: Paul Berkowitz <email@hidden>
Date: Thu, 17 Dec 2009 09:11:27 -0800
To: "email@hidden" <email@hidden>
Subject: 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
_______________________________________________
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