File Explorer in VBA

ybg1 · February 6th, 2012, 07:57 AM

Hi
How do you open File Explorer in VBA that will open in MyComputer
and not in MyDocuments?
Thanks

disel2010 · February 6th, 2012, 10:49 AM

I don't think you can.

You can easily specify a folderlocation with InitialFileName but there is no special folder or environment variable for "My Computer".

ybg1 · February 7th, 2012, 07:52 AM

The resolution to this is the following link:

http://bytes.com/topic/visual-basic-...og-my-computer

disel2010 · February 7th, 2012, 08:21 AM

Nice,

thanks for sharing.

Just curious now which file explorer you're using in access vba.

I was thinking of Application.FileDialog but this doesn't have an InitialDirectory param (and InitialFileName doesn't work with only the My Computer CLSID).

ybg1 · February 7th, 2012, 01:16 PM

have a look at this link there are lots of demos and usefull info

http://www.utteraccess.com/forum/Dra...-t1973842.html