View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default 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