Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default UserAccounts.CommonDialog - How it works

Sure would oblige a message box returning the full path of a file browsed.
--
Thanx & Best Regards,
  #2   Report Post  
Posted to microsoft.public.excel.programming
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,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL2003 - CreateObject("UserAccounts.CommonDialog") Faraz A. Qureshi Excel Programming 3 March 2nd 10 01:35 PM
CommonDialog control issue Rob Docherty Excel Programming 2 August 25th 05 06:21 PM
Using commondialog.showopen Didier Poskin Excel Programming 4 June 5th 05 10:07 PM
CommonDialog Error Syed Zeeshan Haider[_3_] Excel Programming 3 November 19th 03 07:50 PM
CommonDialog Error Clement Excel Programming 2 November 19th 03 11:19 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"