Axolot Data

I've just hit a problem with Autofilter..

I have a sheet with a space in the sheet name "Kheops Orders".

When I try to create an autofilter, I receive an error message :

Error in formula Kheops Orders!$A$1:$K$2301 Unknown name KHEOPS.

I have worked around it by using an underscore in the sheet name, but it would be better if it was fixed.

Thanks,

Hello

You must put quotes around names with spaces.


Lars Arvidsson

You must put quotes around names with spaces

But how can I do that?

I create the autofilter by calling ...

xlsReadWriteII3.Sheet[0].AutoFilters.Add(0, 0, TotalCols - 1, RowCount - 1);

At no point do I use the sheet name; that's provided by your code.

Is there any chance you could release the .dpk files so that I could rebuild the .bpl file?

Thanks,

Hello

Sorry, of course you can't add any quotes. That's the bug in the code...

Please send me an e-mail and I will send you an update.


Lars Arvidsson

Lars,

I E-mailed you last wek but haven't had a reply. Did you get the message?

Would you please send the update to me at

JoeGriffin <at> cix <dot> co <dot> uk

Thanks,

Hello

I have sent the fix to you now.


Lars Arvidsson