View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_3_] Charlotte E.[_3_] is offline
external usenet poster
 
Posts: 160
Default Path from path???

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