| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning a file name after checking for specific character
Hi,
I need to return the first set of characters before an underscore in a filename. slightly disappointed as I can't do this: FName = Chr$(34) & Left(ActiveWorkbook.Name, Search(Chr$(95), ActiveWorkbook.Name)) & Chr$(34) How else can I do it, apart from using another workbook cells to return the activeworkbookName and then using the len and search function....this is part of a loop of many workbooks. Many thanks Wendy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking the content of a cell if it starts with certain character | Excel Programming | |||
| Checking a String's last character | Excel Programming | |||
| Checking to see whether a string contains a certain character | Excel Programming | |||
| After checking control checkbox returning focus to the sheet | Excel Programming | |||
| Checking the last character is in a list | Excel Programming | |||
Threaded Mode
