View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Lawson[_3_] Matt Lawson[_3_] is offline
external usenet poster
 
Posts: 2
Default Function to return filepath given full filename

I need a function (whether built in or user defined) that can return the filepath (ie C:\mypath ) given the full filename with path ( as returned in the GetOpenFileName function, ie C:\mypath\myfile.xls )

Any help would be greatly appreciated

Matt Lawso