Autofilter on sheets with space in name

[Joe Griffin]

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,

[larsa]

Hello

You must put quotes around names with spaces.


Lars Arvidsson

[Joe Griffin]

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,

[larsa]

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

[Joe Griffin]

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,

[larsa]

Hello

I have sent the fix to you now.


Lars Arvidsson