Custom User form containing a browse to file field

[Fizzyfish]

I need to create a custom form to allow users to enter some data via a text field and a radio selection. Also I need to allow users to browse to a file and select it, after which I can get the file name and put it into a variable for use later.

I can create the user form and user input fields but I am stuck on how to add a file browser control to the form. Can anyone help with this?

Thanks,
Sherry

 

[shg]

See Application.GetOpenFilename

 

[wigi]

get the file name and put it into a variable for use later.

You'd better store the filename in a hidden control, or in the Tag property of an existing control. I do not feel very confortable with "for later use". Depending on what "later" is, the variable could not contain what you wanted

 

[Fizzyfish]

That is exactly what I was looking for. Thanks!

 

[LogicNP]

Look at the controls from Shell MegaPack which allow you to add a file browser control to the form.

 

[Fizzyfish]

You'd better store the filename in a hidden control, or in the Tag property of an existing control. I do not feel very confortable with "for later use". Depending on what "later" is, the variable could not contain what you wanted

The variable works fine, since I pass it to a procedure from the procedure where I create it.

 

[Fizzyfish]

Look at the controls from Shell MegaPack which allow you to add a file browser control to the form.

That is a really cool control, but way over kill for what I need right now. Good to have that information though. Thanks!