FileDialog.InitialView Property

Mick_Webb

New Member
Joined
Apr 4, 2016
Messages
17
Office Version
  1. 2016
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
Does anyone else share my frustration with the following? Or better still has found a solution?


I am using Office 2016 on a Windows 10 64 bit OS.
I cannot get the FileDialog.InitialView Property to take effect - i.e. no matter which of the msoFileDialogView constants I use it is not applied in the dialog when it opens.
It accepts a valid constant value - an invalid one produces an error - and you can read it after writing it, in fact it will still have this value on a sequential run of the dialog, but it does nothing with it.
Different folders come up with different views - I thought it was a reflection of the view set in File Explorer but a folder will come up on the dialog with a different view from File Explorer. I even, programmatically, changed all folders to be of the General type template to no avail.
If I change the view on a folder manually on the dialog it will come up with this on sequential runs - the read value of the FileDialog.InitialView Property being whatever it was set to in the code on the previous run.
I also have Office 2010 on the machine and this comes up the same, so do suspect it is a Windows 10 thing.


Any thoughts appreciated.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,216,138
Messages
6,129,099
Members
449,486
Latest member
malcolmlyle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top