If statement not working....

[bear77]

Please help....

I'm trying to get my IF statement to 'Exit' at this line if there is nothing in the variable strFile.

This is the line of code -

Please Login or Register  to view this content.

But the program just ignores it and carries on through. What am I doing wrong?

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[LordLoki]

Please put the code in code tags.
I would guess that the function wksexists throws an error cause the worksheet does not exists. Cause you have on error resume next nothing happens. Before at the beginning of you function set the function to false then it should work

Sent from my GT-I9505 using Tapatalk

[6StringJazzer]

Move your End If as shown. (Other solutions are possible.)

Please Login or Register  to view this content.

[bear77]

Thanks - tried moving the end if but no luck. This line //strFile = Application.GetOpenFilename("Text Files (*.csv),*.csv")// opens Windows explorer so that the user can choose a file. In the event that someone chooses not to select a file but instead clicks CANCEL from the file dialogue box they get a debug error - presumably because strFile is blank. Hence If strFile <> "" Then End If

How do I put my code in quotes by the way? Are we talking about ""? Relative newbiee...

[LordLoki]

Did not work cause strfile becomes False when you click Cancel not ""

This should work

Please Login or Register  to view this content.

[6StringJazzer]

How do I put my code in quotes by the way? Are we talking about ""? Relative newbiee...

No--tags, not quotes.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

You can type in the tags, or highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[bear77]

Many thanks to all who responded. I've sussed it now - needed to change the strFile type from string to variant and then use <> 0 to check for its existence!