Below is the code I am using in 2003 vba. It does not work in 2007.

Dim wks As Worksheet
If Left(wks.Name, 1) = "R" Then - 07 does not like Left

end if

I tried finding the correct function on 2007 but got no where with it. Any
help would be greatly appreciated.
Ta,
Martin

try ...
If VBA.Strings.Left(wks.Name, 1) = "R" Then
regards
r


Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"Martin Wheer" wrote:

> Below is the code I am using in 2003 vba. It does not work in 2007.
>
> Dim wks As Worksheet
> If Left(wks.Name, 1) = "R" Then - 07 does not like Left
>
> end if
>
> I tried finding the correct function on 2007 but got no where with it. Any
> help would be greatly appreciated.
> Ta,
> Martin
>
>
>

as given, the wks object hasn't been set to a worksheet

if you add for example
Set wks = ActiveSheet
it works fine:

Dim wks As Worksheet
Set wks = ActiveSheet
If Left(wks.Name, 1) = "R" Then
'do something
End If


"Martin Wheer" <(E-Mail Removed)> wrote in message
news:h0l3hj$nlm$(E-Mail Removed)...
> Below is the code I am using in 2003 vba. It does not work in 2007.
>
> Dim wks As Worksheet
> If Left(wks.Name, 1) = "R" Then - 07 does not like Left
>
> end if
>
> I tried finding the correct function on 2007 but got no where with it.
> Any help would be greatly appreciated.
> Ta,
> Martin
>

Hi,
Thanks for the help.
Ta,
Martin

"Patrick Molloy" <(E-Mail Removed)> wrote in message
news:E73EC0B2-2DF5-46AB-BF38-(E-Mail Removed)...
> as given, the wks object hasn't been set to a worksheet
>
> if you add for example
> Set wks = ActiveSheet
> it works fine:
>
> Dim wks As Worksheet
> Set wks = ActiveSheet
> If Left(wks.Name, 1) = "R" Then
> 'do something
> End If
>
>
> "Martin Wheer" <(E-Mail Removed)> wrote in message
> news:h0l3hj$nlm$(E-Mail Removed)...
>> Below is the code I am using in 2003 vba. It does not work in 2007.
>>
>> Dim wks As Worksheet
>> If Left(wks.Name, 1) = "R" Then - 07 does not like Left
>>
>> end if
>>
>> I tried finding the correct function on 2007 but got no where with it.
>> Any help would be greatly appreciated.
>> Ta,
>> Martin
>>

Hi,
Thanks for the help.
Ta,
Martin


"r" <(E-Mail Removed)> wrote in message
news4E748C4-BE5C-4824-9102-(E-Mail Removed)...
> try ...
> If VBA.Strings.Left(wks.Name, 1) = "R" Then
> regards
> r
>
>
> Il mio ultimo lavoro ...
> http://excelvba.altervista.org/blog/...ternative.html
>
>
> "Martin Wheer" wrote:
>
>> Below is the code I am using in 2003 vba. It does not work in 2007.
>>
>> Dim wks As Worksheet
>> If Left(wks.Name, 1) = "R" Then - 07 does not like Left
>>
>> end if
>>
>> I tried finding the correct function on 2007 but got no where with it.
>> Any
>> help would be greatly appreciated.
>> Ta,
>> Martin
>>
>>
>>