INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Get access to underlying windows explorer object an manipualte

Get access to underlying windows explorer object an manipualte

(OP)
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/office/forum/of...

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/ff...

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

RE: Get access to underlying windows explorer object an manipualte

(OP)
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/questions/2126218...

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

RE: Get access to underlying windows explorer object an manipualte

(OP)
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

RE: Get access to underlying windows explorer object an manipualte

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





RE: Get access to underlying windows explorer object an manipualte

(OP)
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 banghead

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close