Hi shg,

Sorry.. I probably didn't make it quite clear..
The path where I direct Application.GetOpenFile is not where my .xls resides..
I am trying to read the path name as a string from the App.GetOpenFile variable 'PathName' because I wish to automatically select files at that destination to read their filename without having to use the App.GetOpenFile again..