Opening an instance of Windows Explorer from Access

[frankis]

I'm trying to open Windows Explorer at a folder that relates to the current record.

n Error GoTo StartError
Dim objOutlook As Object

'Create a Microsoft Outlook object.
Set objExplorer= CreateObject("WinExplorer.Application")

Set objExplorer = Nothing

Exit Sub
StartError:
MsgBox "Error: " & Err & " " & Error
Exit Sub

Is it possible to open Explorer like you would Excel etc?

many thanks

 

[CaptainD]

First off, you create "objOutlook" but you're trying to Set "objExplorer". The name of the object is not important but you have to set the right name.

n Error GoTo StartError
Dim objOutlook As Object

'Create a Microsoft Outlook object.
Set objExplorer= CreateObject("WinExplorer.Application")

Set objExplorer = Nothing

Exit Sub
StartError:
MsgBox "Error: " & Err & " " & Error
Exit Sub

 

[PHV]

open Windows Explorer at a folder
In Access VBA:
FollowHyperlink "\path\to\folder"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CaptainD]

Or

Dim RetVal
RetVal = Shell("C:\WINDOWS\explorer.EXE C:\SomeFolder", 1)