PDA

View Full Version : Change size of BrowseForFolder object



g8r777
08-18-2011, 10:17 AM
I have the following function called when a macro runs:

Function BrowseForFolder(Optional OpenAt As String) As String

Dim ShellApp As Object

Set ShellApp = CreateObject("Shell.Application"). _
BrowseForFolder(0, "Please choose a folder", 0, OpenAt)

On Error Resume Next
BrowseForFolder = ShellApp.self.Path
On Error GoTo 0

Select Case Mid(BrowseForFolder, 2, 1)
Case Is = ":"
If Left(BrowseForFolder, 1) = ":" Then
BrowseForFolder = ""
End If
Case Is = "\"
If Not Left(BrowseForFolder, 1) = "\" Then
BrowseForFolder = ""
End If
Case Else
BrowseForFolder = ""
End Select

ExitFunction:

Set ShellApp = Nothing

End Function

I'd like to specify the size and position of the shell that opens. I'm not sure how. Is there a way to modify the ShellApp object? If so how? I'm not opposed to having open in full screen if there is an easy way to code that.

Thank you.