View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default UserAccounts.CommonDialog - How it works

Not sure what the question is and why want to use the UserAccounts
CommonDialog
Guessing, if you want to browse to a file with a view to opening it, try
something like this -

Sub getOpenFile()
Dim sFile As String
Dim vReturn As Variant
vReturn = Application.GetOpenFilename()
If VarType(vReturn) = vbBoolean Then
MsgBox "User cancelled"
Else
sFile = vReturn
MsgBox sFile
End If

End Sub

See GetOpenFilename in help and its optional arguments.

If you are trying to do something else explain what the overal objective is

Regards,
Peter T

"Faraz Ahmed Qureshi" wrote in
message ...
Sure would oblige a message box returning the full path of a file browsed.
--
Thanx & Best Regards,