Could someone help me to get the path of my mdb filename in VB?
I need to use it in the ADO connection string.
Currently I am using it as a function and hard coding the complete path...
Tried to read through VB Help... tried this as a module in VBA, but didn't work...
Dim fs, d, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(f.Path) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"