| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify the network path a file was opened from (Excel2007)
Not sure if I am using the correct keywords/tricky phrases here but...
I have a workbook placed on our network that contains a macro other can use create a standard report. I want to write into the code, a way to confirm that they are using the network file (most current) and not a copy they placed on their CPU. I have tried the whole path, GetDrive, etc. methods but it only gives me the "mapped name" (ex1: "T:\") and not the actual network path information (ex2: "\\usatx\stdrpts\E&Ocalc\"). Hope this makes sense, any ideas how to get to this level of information in example 2 or other method to confirm they are using the correct file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Format cells to pick up the name of the person who opened the excel in a network | Excel Worksheet Functions | |||
| Path to a network drive | Excel Discussion (Misc queries) | |||
| Can't open excel on network drive, it said somebody has opened it | Excel Discussion (Misc queries) | |||
| file opened twice on network | Excel Discussion (Misc queries) | |||
Threaded Mode
