Yes that seems to work fine now.
Thanks for all the help, much appreciated.
regards
Mike


--- In ExcelReportingAddin@yahoogroups.com, bartsmissaert@... wrote:
>
> 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
> >>
> >>
> >
> >
> >
> >
>