View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Göhring Michael Göhring is offline
external usenet poster
 
Posts: 1
Default Split fullname into Drive, Path and Filename

Hello all,

I need to split up the Fullname of my workbook into Drive, Path, filename;
and to check, if drive is a network share then to change the Drive to UNC.

How can I achieve this in Excel ?

Thanks in Advance

Michael