Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How to find/get the FULL path from a path with pattern recognition???
If I provide these paths: C:\Folder1\Folder2\Folder3\ C:\Fo?der1\Folder2\Folder3\ C:\Folder1\Fol*der2\Folder3\ C:\Folder1\Folde?2\?older3\ C:\Fol?er1\Fo*der2\Fo*der3\ C:\Fol*der1\Folder2\Fold?er3\ ....I would like to retreive C:\Folder1\Folder2\Folder3\ ....in all cases? Apparrently DIR() only give the last folder, and only if the middle folder doesn't contain a pattern char! FileSystemObject won't return and full path if given a pattern path! API 'GetLongPathName' fails completely if using pattern chars! What am I missing?!? ...and if I'm putting in the short name extender (~) everything goes south How to get the FULL path, no matter what pattern chars I have included in the path??? Thanks, CE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove end folder from path found with ThisWorkbook.Path command ? | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Current path to Qualified Path | Excel Programming |