Obtaining windows file history

[jempoole]

Hi,

I want to write a macro which will open a file open dialogue box, with the default address of the last previously opened file which is not an excel file.
Does anyone have any idea if this is even possible using vba in excel?

I assume I'd need to be able to read in the Windows file history.

Thanks.