How to launch Windows Explorer rooted to LAN folder

Excel Help for How To Launch Windows Explorer Rooted To Lan Folder in Analyzing Corporate Financial Data

Forum Topic

Rate this:

(3/5 from 1 vote)

	I need to assign a macro to a button to launch Windows Explorer in single pane view (files names only, no folder tree) rooted to a specific network folder. Using the hyper-link option to the LAN folder works, but it opens up Explorer with the folder pane showing. I only want the file pane. Recording a macro to do this fails altogether as it seems not to capture mouse clicks outside of Excel. Any help will be highly appreciated. Thanks!
	Posted by AAE on 15 Feb 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

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

Displaying page 1 of 1

Find relevant Excel templates and add-ins for How to launch Windows Explorer rooted to LAN folder in the Excel Business Solutions Directory