VBA FileDialog - InitialDir Missing 1

[maxhugen]

In earlier versions of Access, I used the Windows Common Dialog dll (comdlg32.dll) to open the File Dialog. One of the settings I found very useful was the InitialDir property, so that the Dialog would open in a specified folder.

This does not appear to be available in the VBA FileDialog properties. Does anyone know of a way around this?

MTIA

Max Hugen
Australia

 

[1DMF]

http://msdn.microsoft.com/en-us/lib....core.filedialog_properties(v=office.15).aspx

I believe you want : InitialFileName

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[maxhugen]

Du-oh, of course! Thanks 1DMF

Max Hugen
Australia

 

[1DMF]

No worries, it's easy to be caught out by a property name change!

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music