ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserAccounts.CommonDialog - How it works (https://www.excelbanter.com/excel-programming/440414-useraccounts-commondialog-how-works.html)

Faraz Ahmed Qureshi

UserAccounts.CommonDialog - How it works
 
Sure would oblige a message box returning the full path of a file browsed.
--
Thanx & Best Regards,

Peter T

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,





All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com