Browse Method for User Inputed File Location

[SamuelIngvalson 0]

I need the user to input the location of a file so that my script can open that file and perform some tasks. I wrote code that allows the user to manually type in the full directory of the file using a simple input box.

$Input1 = InputBox("InputBox name","Please enter the location of the file. (C:\Users\sjohnson\Desktop\file.xlm)")

This is not a very efficient or user friendly way to do this, it is a pain for the user to type the full location of the file.

I would like to have some type of "Windows Explorer" type input method, where the user can browse through disk drives and folders to select the requested file. How can I accomplish this? Is there any scripts already written that do this? 

Another possible solution would be a drag and drop box, where the user could just drag and drop the requested file.

Any help will be greatly appreciated.

Edited July 18, 2013 by SamuelIngvalson

[JLogan3o13 1,368]

Hi, Samuellngvalson, welcome to the forum. Check out FileOpenDialog or FileSelectFolder in the Help File.

[Melba23 2,858]

SamuelIngvalson,

Or you could use my ChooseFileFolder UDF - look in my sig for the link.

M23

[JLogan3o13 1,368]

Between ChooseFileFolder, RecFileListToArray and ExtMsgBox, I see three UDFs that should be core in the next release

[Melba23 2,858]

JLogan3o13,

Check out the _FileListToArrayRec function in the latest Beta - it might look familiar.

M23

[Chimp 491]

a very simple example to try:

$File = FileOpenDialog('Please choose any file', '', 'All (*.*)', 1)
MsgBox(0,"File selected:", $File, 5)

bye