• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

current folder

When I use CurrentProject.Path, I get something like this: C:\ABC\123

I just want to return 123.  How would I do this?  Thanks.
0
Sasha42
Asked:
Sasha42
1 Solution
 
Rgonzo1971Commented:
Hi,

a = Mid(YourString, InStrRev(YourString, "\") + 1)

Open in new window


Regards
0
 
mbizupCommented:
s = CurrentProject.Path
msgbox mid(s, instrrev(s,"\") +1)

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now