View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default just file name no path

Hi Musa

You can use Dir

MsgBox Dir(fileToOpen)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"musa.biralo" wrote in message ups.com...
Hi
is there a way to get the file name only? Using this
fileToOpen = Application.GetOpenFilename("DBF Files (*.dbf), *.dbf")

i got complete path. i want the path as well as file name. So, for
path this is ok to me but not for the file name. Please help me or
direct me to the right place.

musa.biralo