File Path Class
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! |
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! |
File Path Class
That would be the method internal to the Path class. The reason why I
want a class to do this is that it is tedious to, for example, get the path of the parent's parent folder. I would have to take the ubound of the array, iterate over each element in the array until ubound-3, properly join them with the appropriate path separator, etc. I just want a one-line command to do it, since I have to do it all the time. Also, a class could be designed to handle UNIX, Windows, and (perhaps) Mac paths natively. It could also have built in functions to test whether or not the path exists, if it is a folder or file, return a scripting.file object corresponding to the path, etc. Tom Ogilvy wrote: 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) |
All times are GMT +1. The time now is 01:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com