how to do reverse index in VBA

Question

I don't know anything about VBA but I need to get the file name out of a file full path.

So for a string like "c:\something\somethingelse\file.name" I need to get "file.name" out. Also how can you get a quote in a string such as " " "? backslash doesn't seem to work.

Answer 1

To get a quote in a string use two quotes ("")

To find the location of the slash from the end, use InstrRev()

Answer 2

the DIR() function will return the filename. You need to add a reference to the Microsoft Scripting runtime.