Hi Mike,

I think this will solve your problem:
Open that .rcf file again
Go to code line with number 170 and change the Clng to Val
Save the file.
Close Excel and restart (as the old code has now been imported) and try
again.

Regards, Bart



> --- In ExcelReportingAddin@yahoogroups.com, "bartsmissaert"
> <bartsmissaert@...> wrote:
>>
>> When adding entries and having comma separated Read codes in the Read
>> code box there would be a dialog saying that this is slow and advising
>> to switch to SQLite method. This is because by default adding entries
>> was run with the old method. This has now been altered and this will now
>> always run with the SQLite method.
>> Old method will soon be thrown out as it is not maintained and it will
>> make the code smaller and simpler.
>>
>> One .rcf file (ApptsStatsLimitUsersExtraWHERE.rcf) wouldn't run with
>> Firebird due a bit of SQL it didn't like and have changed this now.
>>
>> Version 21.55
>>
>> Bart
>>
>
> Hi Bart
> thanks, the install error was caused by the Word add-in, now rectified.
> The RCF with v 21.55 now works and picks up entries. However, there is a
> slight problem
>
> When putting the user id's in the description box it seems to work fine
> until I include a longish number i.e. (these are all valid user id's on
> our system)
>
> 11,13,14 works OK
>
> 11,13,14,53083455 gets Overflow error
>
> Any ideas?
> regards
> Mike
>
>