Get access to underlying windows explorer object an manipualte

[1DMF]

Hi,

I seem stuck understanding how I get access to the windows explorer object and alter it.

I have a browser control on a form and I use the controlsource to navigate to a network folder.

How do I then interact with this, such as change the view or enable the preview pane?

My unbound browser control is called 'Explorer'

And according to this page :

http://answers.microsoft.com/en-us/...-control/15d5d025-e4d3-4f9a-9190-826a00ccbe66

The control property I need is : CurrentViewMode

So I have tried Me.Explorer.Object.Document.CurrentViewMode = 3

But it errors with 'Object doesn't support this property or method'?

I've been scouring :

https://msdn.microsoft.com/en-us/library/office/ff822727(v=office.14).aspx

But cannot find anything to help?

Where is information on how to use this control an manipulate the underlying explorer window?


"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

 

[1DMF]

I give up, I've hunted high and low for hours and all I find is a plethora of people asking the same question, being told the same thing about Me.Explorer.Object.Document.CurrentViewMode and it not working?

The only thread I have manage to find with a solution is this one..

https://www.experts-exchange.com/qu...s-How-to-change-the-WebBrowser-File-View.html

Which basically says Me.Explorer.Object.Document.CurrentViewMode , is rubbish, it doesn't work and the only solution is to use sendkeys?

Only this still doesn't work because of the security warning, so until I have worked out how to stop the security working , it seems impossible to change the view with VBA code?


"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

 

[strongm]

>t seems impossible to change the view with VBA code?

Pah!

See my code in

http://www.tek-tips.com/viewthread.cfm?qid=1735226.

CurrentViewMode works fine. Ignore the doubters.

 

[1DMF]

I think the confusion lies between the built in webcontrol and an ActiveX component.

There isn't even a Navigate method with the built in web control


"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

 

[strongm]

Are you sure? The built-in webcontrol in my copy of Access is simply a wrapper of the Microsoft Internet Controls (a quick look at references in the VBA IDE once you have added a webcontrol to a form will show you this). The Object property exposes the full set of properties of the underlying control.

So ... yes, the Access 'native' webcontrol does not directly have the method, but the control it wraps and completely exposes does.

Now, the next problem is that CurrentViewMode can't be set whilst the explorer window is still loading (and will give the misleading error message that you are seeing), so you need to wait until the readystate is complete

 

[1DMF]

It doesn't work any way for what I'm trying to do, poxy thing is offering XLS / DOC etc as downloads rather than embedding in browser control. PDF & TXT so far are the only files that 'load'

I'm trying to build a document management GUI with preview, but it's a damn nightmare!

I can't get the web browser to embed docs and I can't get OLE for XLS / WORD working either

Your assistance is much appreciated.






"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