| 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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ThisWorkbook.FullName
What you want is...
ThisWorkbook.Path HTH, Gary Brown "Steph" wrote: 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?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ThisWorkbook.FullName
Hi Gary. This Workbook.Path gives me the same thing as Fullname, which is
the G:\ rather than the \\servera\ "Gary Brown" wrote in message ... What you want is... ThisWorkbook.Path HTH, Gary Brown "Steph" wrote: 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?? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ThisWorkbook.FullName
Here's a link to a couple of posts from Jim Rech and Tom Ogilvy about how to
convert the drive letter to the UNC path: http://groups.google.com/groups?thre...%40cppssbbsa06 Steph wrote: 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?? -- Dave Peterson |
| Reply |
| 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)
Linear Mode
