|
Answer» right peeps bit of a conundrum this one
i am looking for some CODE that COULD tell me where a file has been opened from, ie if i have 2 drives, 1 LOCAL and 1 networked and a file that is stored on both and has the same name, i want to know which one was opened.
must admitt if someone knows the code for this then we have unkown genius's in our mist
happy huntingRight click a file and click properties. It shows you the date and time.do you know the VB code for this though and i don't think it tells you what location the file was opened from.....no worries i've found the answer, if anyone was interested you would use the following code
Function MyFullName() As String
MyFullName = ThisWorkbook.FullName
MsgBox (MyFullName)
End Function
|
