Hi All, I have run into a problem using the shell command with VBA on a userform.
I need to open a explorer window and navigate to our document management software.
x = Shell("c:\windows\explorer.exe ""documentum\Custom Query\xyz_prod_doc""", vbNormalFocus)
This does not work. It will open the explorer window but only show the "my documents" folder.
the problem is "documentum\Custom Query\xyz_prod_doc" is not a physical address.
I can use the shell command to open any physical address (aka, C:\temp) with no problems.
When explorer is open, we typically paste "documentum\Custom Query\xyz_prod_doc" into the address bar and then hit enter. My goal is to replicate this with VBA, and if i can get that far, I'd like to pre-populate a sql query from the VBA as well to automate some document searching. (So I am also interested in passing other information to the explorer window)
Essentially, i need to replicate opening explorer, pasting a address, (as i don't seem to be able to pass it with shell), and hitting enter, to start.
Thanks for any suggestions or ideas.
Bookmarks