Jump to content
Sign in to follow this  

Allow user to browse to select file to use with gui.

Recommended Posts

Wanted to make a gui to allow a browse like feature to search through users computer directory to open an excel file for the script since the name can vary.  Anyone have an example or what I can look at to accomplish this?


Share this post

Link to post
Share on other sites


FileOpenDialog or my ChooseFileFolder UDF sound like what you need. ;)


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:


ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area


Share this post

Link to post
Share on other sites

my fav way to open, this looks for and parses a csv:

Func import()
    Local $var = FileOpenDialog("Select only one file.", @ScriptDir & "\", "Files (*.csv)", 1)
    If @error Then
        _FileReadToArray($var, $zInput)
        For $i = 1 To UBound($zInput) - 1

            $Line = StringSplit($zInput[$i], ",", 1)
            $zVar1 = $Line[1]
            $zVar2 = $Line[2]
            _GUIListViewEx_Insert($zVar1 & " | " & $zVar2) ; <~~ this puts the results into a list view.
EndFunc   ;==>import

C0d3 is P0etry( ͡° ͜ʖ ͡°)

Share this post

Link to post
Share on other sites

Ah cool thanks Melba.  Just looking for a clean way to tag my $oExcel file.  Cool func Kov I'll save that one.  Always have a use for that one.

Edited by dar100111

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...