Find invalid character in string

[duckboy1981]

Hi all,

I have a macro that asks the user to enter a file name and have written a small function to search the name given to the file to find any invalid characters, trouble is I must be doing something wrong as I doesn't work. Everytime I write something in the box I'm told it's invalid, regardless of weather it actually is or not.

Function -

Please Login or Register  to view this content.

I call the function like this -

Please Login or Register  to view this content.

If anybody could let me know where I am going wrong I'd appriciate it.

Thanks.

[Richard Schollar]

Hi

Default value of a Boolean is False and you never actually set it to True - hence the Do condition is always True.

Richard

[jasoncw]

You have the <> 0 at the end, but you need to list it for each test. For example:

Please Login or Register  to view this content.

HTH

Jason

Edit: Richard's response, too.

[DonkeyOte]

I think you could argue that the <> 0 is not required given only the value 0 equates to FALSE ... any other value equates to TRUE by default

[duckboy1981]

Thaks for replies all. I have amended the fucntion so every test has '<> 0' at the end and switched the result to 'True' if any of the tests return a result other than 0

It's now allowing me to progress all the time if I write -

Please Login or Register  to view this content.

And not allowing me to progress at all if the code is -

Please Login or Register  to view this content.

I'm probably just being a fool, but if you could have a look again Id apriciate it.

Thanks.

[jasoncw]

Try chaning to the following:

Please Login or Register  to view this content.

HTH

Jason

[duckboy1981]

Sorted - Thanks muchly

[jasoncw]

Glad it helped.

Jason