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.

user27414 · Accepted Answer · 2009-09-23 17:36:52Z

5

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

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

answered Sep 23, 2009 at 17:36

user27414

Sign up to request clarification or add additional context in comments.

4 Comments

Tom Over a year ago

Thanks Jon B. Is there a substring equivalent as well?

Tony Toews Over a year ago

Jon, well, I'll be darned. I actually learned one useful thing this year. I had no idea that InstrRev existed. Ah, I see it is new in Access 2000.

onedaywhen Over a year ago

@Tony Toews: Open the Visual Basic Editor. From the menu, choose: View, Object Browser. Change the dropdown from 'All Libraries' to 'VBA'. For each module and class, study every function and learn what it does. Advance class: learn which functions can be used in Access Database Engine SQL outside of the Access UI.

Oorang Over a year ago

John, this seems to be a correct and acceptable answer. You might considering accepting it.

Harry · Accepted Answer · 2009-09-23 18:46:56Z

0

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

answered Sep 23, 2009 at 18:46

Harry

231 silver badge3 bronze badges

1 Comment

Ken White Over a year ago

Why would you do that (add the overhead of the entire scripting runtime) when you can simply use built-in string functionality?

Collectives™ on Stack Overflow

how to do reverse index in VBA

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related