How do I use InStr to find a '-' in the filename?

**Lee-337** · 07-09-2013, 01:51 PM

Hey all,

I'm trying to find the '-' in a file name using InStr. Here's the code:

Please Login or Register  to view this content.

I keep getting a value of 0. Shouldn't I get a 9? I think I'm missing something.

**tigeravatar** · 07-09-2013, 01:54 PM

Take out the quotes from "MyFileName" within the InStr method, like so:

Please Login or Register  to view this content.

Otherwise it is performing the InStr method on the string "MyFileName" instead of the variable MyFileName (which evaluates to the string "Operator-Joe.xlsm")

**Lee-337** · 07-09-2013, 02:32 PM

That did the trick! Thanks for the help.

How do I use InStr to find a '-' in the filename?

LinkBack

Thread Tools

Rate This Thread

Display

How do I use InStr to find a '-' in the filename?

Re: How do I use InStr to find a '-' in the filename?

Re: How do I use InStr to find a '-' in the filename?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions