PDA

View Full Version : Excel Vista



makako
11-16-2006, 08:35 AM
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
11-16-2006, 10:10 AM
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
11-16-2006, 10:44 AM
thanks, its beta 2 and only in code

Ken Puls
11-16-2006, 10:47 AM
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
11-16-2006, 10:50 AM
im sure it is cause its running on 2003, the alert points exactly on the sentence :
left(mystring,2)

Zack Barresse
11-16-2006, 02:03 PM
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
11-16-2006, 02:23 PM
Zack, I think he's saying that it is working on 2003, but is not working on 2007. ;)

Zack Barresse
11-16-2006, 02:25 PM
Ah. I'd still like to see the code. Also, the OP should check the Left(), Left$(), Right(), Right$(), Mid() & Mid$() functions.

Ken Puls
11-16-2006, 02:30 PM
Agreed, Zack.

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