Have tested this now and with that little alteration it runs fine, even
with the comma separated users as you described.

One other thing you may want to add to the file is this line of code:

AutoFilterSheet ActiveSheet, False, , False

Put it at the very end before the line that says:
UpdateTimer 1, 1, 1, 1, False

Doing this will automatically add the auto-filter buttons for you in the
sheet.

Bart



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