Open folder in Explorer

Good morning,

I was wondering if it is possible to use a macro open a folder in Windows Explorer. Previously someone on this forum taught me how to open an Excel file from a macro, but in this case there will be a new file every week. As the files will all be stored in the same folder, I thought it would be easier to open the folder in the normal Explorer view and select the file manually than to change the macro every week.

I am using Windows XP and Excel 2003. My programmes are run from the C drive, but my documents are stored on the E drive. What I am looking for really is a line that says: open in Explorer E:\data\new\processed

Is that possible? I would be most grateful for any suggestions.

Not really. I am not looking to zip a file. I wish to select a file from a specific folder. So really I am looking to skip 'Start - My Computer - E - Data - New - Processed' and go straight to the window that shows the contents of the Processed folder.

Have been messing with the code and have incorporated it in the overall macro, but still cannot get the pop-up window to go directly to the right folder. It opens either my desktop, or the last folder I was in when I opened a file. Been trying with ChDir, which seems to be ignored entirely, and have tried replacing bits that say 'title' with the location (I guess I didn't read your comment correctly), which isn't recognised.

Any thoughts?

That's nailed it!

Needed to use the ChDrive function, and had put the ChDir below instead of above the sWb = Application.GetOpenFilename(sFil, iFilterIndex, sTitle).

Working smoothly now. Many thanks.

Hi Rob,

well worth the experiment.

Indeed, the ChDrive is not required because the ChDir has the drive letter in it. So it works fine without.

As for the ChDir location, it does not work when it is below the line sWb = Application.GetOpenFilename(sFil, iFilterIndex, sTitle), but you are absolutely correct that it works when placed above the line On Error GoTo err_handler

Why is it that everything I get stuck on ends up with a one-line solution? I must either be thinking this is more complicated than it is, or I am just dim.

Thanks again.