button that opens open dialogs but saves path to sheet
Hi Cereldine,
yes, it is possible to get path from full file name.
You can use this function:
Function Folder(FullFileNameIncludingPath)
Dim fs As Object
Set fs = CreateObject("scripting.filesystemobject")
Folder = fs.GetFolder(FullFileNameIncludingPath)
End Function
Regards,
Ivan
|