Common Dialog Box won't observe INITDIR value

Posted on 2009-07-02
Medium Priority
Last Modified: 2013-11-25
I have a form with a lot of command buttons all launching the COMMON DIALOG BOX ( names CD1 in my app)
Under each command button there is a different CD1.INITDIR value (for different folders on the drive)
The problem is that the COMMON DIALOG control is not changing to each individual directory. Whatever one I choose first, is the one that each COMMAND BUTTON opens up, regardless of what the CD1.INITDIR value is set to. I even DEBUGd it and watched the value of INITDIR and it IS CHANGING to the right folder, but the DIALOG box keeps opening up to the same folder as the first one I pick.

On Error GoTo ExitMe
seld = 2
Command2.Value = 0
CD1.InitDir = Text37.Text
CD1.Filter = "MP3 Audio File (*.mp3)|*.mp3"
CD1.DefaultExt = "mp3"
CD1.DialogTitle = "Select Audio File"
CD1.CancelError = False
Text2.Text = CD1.FileName
CD1.FileName = ""
Exit Sub
MsgBox "Error " & Err.Number & ": " & Err.Description & vbCrLf & "in Save" & vbCrLf & "The error occured at line: " & Erl, vbAbortRetryIgnore + vbCritical, "Error"

Open in new window

Question by:rbend
  • 2
  • 2

Expert Comment

ID: 24769055
where is CD1 declared? If it is outside of this sub, maybe if you move it into this sub it will reload properly since it will go out of scope at the end of the sub.

Author Comment

ID: 24769174
The same code as above is in each COMMAND button, with only 2 things changed.. one being the initial directory of CD1
So I would say it is declared in every button

Accepted Solution

rbend earned 0 total points
ID: 24771582
Found my own solution:
This works everytime:

Function fBrowseForFile(pathto)
' This function opens a common file browsing dialog box
' pointed at the local C:\ drive.  When a file is selected
' this function will return the path and filename in a string.
' If cancel is clicked or the browse window is closed without
' a file being selected, the function returns an empty string.
sBrowsePath = pathto
sBrowseFilter = "All Files|*.mp3"
Set oBrowseDialog = CreateObject("UserAccounts.CommonDialog")
oBrowseDialog.Filter = sBrowseFilter
oBrowseDialog.InitialDir = sBrowsePath
oBrowseDialog.Flags = &H80000 + &H4 + &H8
fBrowseForFile = oBrowseDialog.FileName
End Function

Open in new window


Expert Comment

ID: 24772984
That should do it, the main point being that you are creating it inside the function.  There is probably a
Dim CD1 statement at the form level, moving that inside the function would have the same effect.

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Here is a method which can be used to help resolve a "Content Index Failed" error on a Microsoft Exchange Server.
Disk errors can be the source of sundry problems for the Exchange server, the most common one being that the database fails to mount.
how to add IIS SMTP to handle application/Scanner relays into office 365.
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question