Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Late binding works only at some PCs

Status
Not open for further replies.

waldemar

Programmer
Nov 15, 2001
245
DE
This function is supposed to get a Folder Name from the User, but it works only on some PCs....?

Function findHome() As String
Dim shellapplication As Object
Dim folder As Object
Dim optns As Integer

Set shellapplication = CreateObject("Shell.Application")

If Instructions = "" Then Instructions = "Select Home folder"
optns = IIf(ShowEditBox, 17, 1)
Set folder = shellapplication.BrowseForFolder(hWndAccessApp, Instructions, optns)
If folder Is Nothing Then
findHome = ""
Else
findHome = folder.self.Path
End If

Set shellapplication = Nothing
Set folder = Nothing
End Function


On some PCs the Code stops at "findHome = folder.self.Path"... does anybody have an idea?

Regards
waldemar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top