Keywords Control

7 posts / 0 new
Last post
avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28
Keywords Control

Hi Brian
I may have asked already this question, I apologize if this is the case. In my old age I tend to be a bit senile. What were we talking about? Ah, keywords. Yes. Here is the problem.
Not surprisingly function is a keyword in Idea, unfortunately function is also a part of the subtotal method in excel and is responsible for the decision what are you subtotaling: sum, count, etc. luckily the default is sum and usually you can get around the problem by omitting this argument while calling the subtotal method from IDEA maco, but, you know, we guys tend to seek for a straight solution rather than  a work-around..
Any IDEA?
 
Thanks and have an enjoyable weekend
Avi Kerem

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Avi,

I am not sure if I am following you.  So are you creating an Excel spreadsheet from within IDEAScript?  If so wouldn't the terms for excel me within double quotes so they wouldn't cause a problem for your IDEAScript code?  Any chance you can share some of the code that is causing you the problem.

Thanks

Brian

avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28

I am uploading here the IDEA Project Folder that demonstrates the problem.
Regards
Avi Kerem

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Thanks Avi, I will look at it this weekend.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Avi, thanks for the files but unfortunately I can't read them, can you send them by a different method.

avikerem's picture
avikerem
Offline
Joined: 04/07/2015 - 00:28

trying again

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Avi,

Same problem, are you using the Unicode version?  I am on ASCII and that might be the problem.  If so maybe try to copy the script file to something like Notepad++ and save it as a text file.  That might get around the problem.

Brian