Explorer Problem

[berg43]

I am trying to open explorer at d:\my documents,
however I get message "file not found"
I am using the following command:

Private Sub Command50_Click()
Dim stAppName As String
stAppName = "explorer""d:\my documents"""
Call Shell(stAppName, vbMaximizedFocus)
End Sub

Advice is very much appreciated.
I am using Access 2000

 

[Molby]

Try here: thread707-821824

 

[MoLaker]

Two problems. First, the code s/b...

Private Sub Command50_Click()
Dim stAppName As String
stAppName = "explorer.exe d:\my documents"
Call Shell(stAppName, vbMaximizedFocus)
End Sub

Second, be careful about "My Documents". Depending upon which OS you are using, "My Documents" may not located where you think. It's location can be different for each user. A typical path to My Documents with Windows 2000 is C:\Documents and Settings\Administrator\My Documents where "Administrator" is the logged on user name. But, since your path is on the D: drive, perhaps you are okay if it is a manually created directory. Just consider whether or not you plan to use this database on different computers.