How do you convert "CurrentProject.Path" to a string so that­ I can use as a public const
it in other code, what is the best way to do that?

dim mPath a string
mPath = CurrentProject.Path & "\"

but why don't you just use CurrentProject.Path when you need it? Global variables can be forgotten so it is best not to use them if you don't need to

Sometimes you get so wrapped up in what you think you want to do you forget the KISS principle. "Keep it simple stupid"

Thanks.

you're welcome

the simplest solution is usually the hardest one to find