Excel Vista

[makako]

Hi, Im using the new excel and i have trouble with some formulas, LEFT, for example is not working, I cannot use my spreadsheets and other code in my userform, is there a library i should use?

[Ken Puls]

What version of Excel 2007 are you using? Beta1, Beta2, Beta2 Tech Refresh or the RTM version that you would have got from an MSDN subscription?

And are you having issues with LEFT as a worksheet formula, or just in code?

[makako]

thanks, its beta 2 and only in code

[Ken Puls]

Okay, I'm not sure I'll be able to help you, as I don't have the plain Beta2 version installed (I'm using the RTM version.)

Having said that, can you post the offending code? Maybe someone else can come along who does have that version, or maybe you have a syntax error that is not Beta related at all.

[makako]

im sure it is cause its running on 2003, the alert points exactly on the sentence :
left(mystring,2)

[Zack Barresse]

Running on 2003 or 2007? It's one or the other. Also, post your code and the exact error message received, along with pointing out any highlighted lines or special circumstances.

[Ken Puls]

Zack, I think he's saying that it is working on 2003, but is not working on 2007.

[Zack Barresse]

Ah. I'd still like to see the code. Also, the OP should check the Left(), Left$(), Right(), Right$(), Mid() & Mid$() functions.

[Ken Puls]

Agreed, Zack.

Mukako, it would also be nice to know what the value of "mystring" is when it fails.