We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to get a File Import Dialog box

bhanly
bhanly asked
on
Medium Priority
157 Views
Last Modified: 2010-05-03
I want to prompt the user to choose the files he/she wants to import using a dialogbox.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
bhanly,
Drop a commanDialog Control to your form, name it comdial, drop a text box in the form, then add a command button to the form, in the click event add the code:


On Error GoTo FileErrorHandler

'Get the File Name from the user
'Get a file name From the User
comdial.DialogTitle = Title
comdial.Filter = "All Files|*.*"
comdial.Action = 2
Text1 = comdial.filename

Exit Sub

FileErrorHandler:
Err.Clear
Resume Next

End Sub
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.