ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Details in dialog_open box (https://www.excelbanter.com/excel-programming/444357-details-dialog_open-box.html)

Master Blaster

Details in dialog_open box
 
Hello Everyone,

When I open a file with the use of File_Open or the icon, I would like
to see the detailed view, instead of the default folder view.

Can I accomplish this via a Macro or add-in ?

Thank you in advance,

Javed

Details in dialog_open box
 
Use of FileDialog object of Application required for this purpose

This object has a property InitialView which can be set to the
following constants

msoFileDialogViewList
msoFileDialogViewThumbnail
msoFileDialogViewDetails

One snippet for reference

With Application.FileDialog(msoFileDialogOpen)
.InitialView = msoFileDialogViewThumbnail
If .Show Then .Execute
End With


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com