Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Maybe I can do something a little different -
LCase(ThisWorkbook.FullName) returns a full path. I can change the Fullname to simply Name. But then LCase(file) still returns a full path. How can I change LCase(file) to return the file name only without the path? Dim i As Long Dim file As Object Dim Files As Object FileCountOK = True Set Files = pzFolder.Files For Each file In Files If LCase(file) < LCase(ThisWorkbook.FullName) Then |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert ThisWorkBook.FullName as Link in Email | Excel Discussion (Misc queries) | |||
ThisWorkbook.FullName | Excel Programming | |||
Excel 2000 VBA ActiveWorkbook.FullName | Excel Programming | |||
Split fullname into Drive, Path and Filename | Excel Programming | |||
Looking for Excel function to resolve userid to fullname. | Excel Programming |