excel Application.FileDialog sort

[Thomas.Koerfer]

I'm wondering if there is any method to pre-sort the files shown in the
FileDialog Object.

Thanks in advance

Tom

 

[Perry]

Assuming "f" is an instantiated object variable pointing to
a FileDialog object, use below statement to toggle the view to Details view

f.InitialView = msoFileDialogViewDetails

Now users can sort the files according to their own wishes.

Krgrds,
Perry

 

[Thomas.Koerfer]

I did that already. But in this view I want to pre-sort the files.

 

[Perry]

I don't think you can invoke the internal command to execute sorting on the
FileDialog listview
without comprehensive API calls.
Maybe someone else has tweaked this ...

My opinion:
I would invest in convincing my principal of the fact that some user
guidance/education will turn out (more) rewarding.

Krgrds,
Perry