Prev: Excel instance isolation problem
Next: Inconsistent behaviour of attributes accessed through structured r
From: Faraz Ahmed Qureshi on 9 Mar 2010 05:41
Sure would oblige a message box returning the full path of a file browsed.
--
Thanx & Best Regards,
From: Peter T on 9 Mar 2010 07:45
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" <FarazAhmedQureshi(a)discussions.microsoft.com> wrote in
message news:EC41B4F2-6780-4FB2-BB46-00F8741B7655(a)microsoft.com...
> Sure would oblige a message box returning the full path of a file browsed.
> --
> Thanx & Best Regards,


 | 
Pages: 1
Prev: Excel instance isolation problem
Next: Inconsistent behaviour of attributes accessed through structured r