Control Windows Explorer Through VBA

[esib]

Hello

Having trouble figuring out how I may do this. Let's say I want an event to open Windows Explorer and then perform operations in that environment. For instance, I want to open windows explorer and then go to the Map Network Drive tool. Is that possible?

Let me know if this is not specific enough.

Thanks

 

[ETID]

...you could have vba write a command prompt "batch file"
a containing "netuse" command string.

and then run that file via the shell command.

 

[IvanMoala]

If you just need to map a network drive then
Here is one of many ways......

Sub Tester()
Dim WshNetwork As Object

Set WshNetwork = CreateObject("WScript.Network")

WshNetwork.MapNetworkDrive "H:", "\\Server\Public"

Set WshNetwork = Nothing

End Sub

If you want to see the Dialog then



Ivan F Moala

http://www.xcelfiles.com

 

[esib]

Thanks for the reply. I should have been more specific. We have an instance of FileNET and project related documents need to be stored there. We do not have FileNET fully integrated with Microsoft Office (FileNET group said there are problems with the integration) and so it is tedious for project managers, analysts, etc... to store documents out there. Mainly they have to create a word doc, then open windows explorer, then find the doc, then drag it into a FileNET library. I would like to be able to add a button that initiates the FileNET import process to Word. Windows explorer has this functionality added when the user installs FileNET. So I was hoping I could launch Windows Explorer and then initiate the import through the windows explorer tools.

This is mainly because I do not know the FileNET VBA objects.

Thanks for any help.