Changing the directory using ChDir

[azizrasul]

Why does ChDir not change the directory in the following code?

    ChDrive "C"
    ChDir Nz("C:\Users\Aziz\Desktop", "")

    strFilePathandName = objExcelApp.Application.GetOpenFilename(Title:="SELECT MS EXCEL FILE", FileFilter:="Excel Files *.xls* (*.xls*),")

 

[smozgur]

Unfortunately this is not the expected behavior of the method I suggested. There is no Excel object that will attempt opening an Excel file in the code or any kind of trigger. In fact, there is basically nothing to do with the Excel in this code and method other than the file filter which basically also has nothing to do with the Excel but only file extension as string value.

May be your Office version has something to do with it or something that I am really missing but it still doesn't make sense since it works as expected in my computer (Office 365). I am really not sure, but here is the Microsoft VBA reference page for the method for more information. Note that you can only use this method to select file or folder in Access. Open or Save parameters are even not valid to be used in Access.

Application.FileDialog property (Access)

Office VBA reference topic

docs.microsoft.com

 

[azizrasul]

I'm using MS Office 2013, although I can't see why that would make a difference. The link you sent looks good. I'll investigate that. If not successful, then will have to live with the fact that I will have to go to the folder and select the file. Thanks for your help.

 

[xenou]

the only thing I can think of is if explorer is set up to somehow respond to single clicks instead of double clicks (for opening files). Not sure if that would apply to file dialogs though (really shouldn't...!)

 

[azizrasul]

I have noticed that sometimes the Password Dialog box appears while in other times it doesn't. Curious.
If I Compact & Repair the db, then it doesn't appear.