| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.FullName
Hi everyone. The below piece of code checks to see if the current open file
name is the same as a file name in a server folder. If LCase(file) < LCase(ThisWorkbook.FullName) Then If LCase(file) returns a server path like \\servera\folder\folder\folder LCase(ThisWorkbook.FullName) returns a path like G:\folder\folder\folder They are the same thing, but according to vb are different. How can I get LCase(ThisWorkbook.FullName) to return \\servera\folder\folder\folder?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert ThisWorkBook.FullName as Link in Email | Excel Discussion (Misc queries) | |||
| Seperating Text in One Field into 2 Fields EG FullName | Excel Discussion (Misc queries) | |||
| 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 | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
