Using MS Explorer in Access or VBA

[CptTom]

Is it possible to shell to MS Explorer, highlight several data files, then import them. OR Can I copy a directory, sort files like *.dat and then import in that order?

Larry

 

[braindead2]

look into your common dialog control

 

[kedrew]

Microsoft has a ActiveX component that you can insert onto a form called "Microsoft Web Browser". It esentially is an instance Internet Explorer running within your Access form.

MS has documentation on their website.

One thing I will warn you about - size the control to the size you want BEFORE saving the form. Once you save, the control size if fixed. The only way to change the size it to delete the existing control and insert a new control. (It took me a while to figure that one out.)

For the rest of your problem, it shouldn't been too difficult to implement - one option would be just to use the OpenForm command with an argument containing your desired URL.

Good luck,

 

[CptTom]

I am not talking about Internet Explorer but Windows Explorer.

Larry

 

[Guest_imported]

You can use IE to point to any local directory via &quot;file://<path>&quot;.