Get File Name and Directory

Excel Help for Get File Name And Directory in Analyzing Corporate Financial Data

Forum Topic

Rate this:

(3/5 from 1 vote)

An easy way to get a directory folder path from the network is with the following VBA code:

VBA Code:

Dim fname as String
Dim diname as String
fname = Application.GetOpenFilename("All files (*.*), *.*")
dirname = Dir(fname)

Note that a file must be selected when the open file window appears in order to return the directory path.

Excel Business Forums Administrator

Posted by Excel Helper on 15 Feb 2007

Find relevant Excel templates and add-ins for Get File Name and Directory in the Excel Business Solutions Directory