File Path Class
If using at least xl2000 or later, why not just use split
vArr = Split(sPath,"\")
ext = split(varr(ubound(varr)),".")(1)
name = split(varr(ubound(varr)),".")(0)
--
Regards,
Tom Ogilvy
"R Avery" wrote in message
...
Does anyone have a nice file path class that can work regardless of
whether or not the path exists? The MS Scripting Runtime object model
provides file and folder objects which are good, but they don't work on
hypothetical paths... also, I think they introduce more overhead than a
simple Path class would that merely stores the current path and can
return new path classes to its parent or to its children, or can return
it's FullName optionally with or without the drive, path, name,
extension...
Any help would be appreciated!
|