Raising a "File Open" dialog box

[mstuehler]

After searching this list, I've learned that you supposedly can create a standard windows "Open File" dialog window using:

Set objDialog = CreateObject("MSComDlg.CommonDialog")

However, when I tested this on a WinXP box, it doesn't work.

After more research, I came across this:

Set objDialog = CreateObject("UserAccounts.CommonDialog")

This works on XP, but it firsts prompts a ActiveX security warning, and I don't know if it works on Win98 or Win2k.

Is there a standard function that works on all WinOS?

Many thanks in advance!

Cheers to all!

 

[PHV]

If inside an html or hta page, you may consider something like this (from Veep in Thread329-696121):
<input type="file" name="myFile" value="Browse for File">

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[zaznet]

I sent in a FAQ answer for this, expect it to be approved and linked to this post soon.

Short answer though in case you can't wait.

Add a line after what you have that reads:

Set SomeVariable = objDialog.ShowOpen

The value in "SomeVariable" will be the TRUE/FALSE result of the dialog event. IE: did the user select a file.

Your file name will exist in: objDialog.Filename

 

[zaznet]

The FAQ got approved already. It's at faq329-5310 and I'll try to add a few more things later on that might benefit others.

Nathan aka: zaz (zaznet)
zaz@zaz.net

http://www.zaz.net/