Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've tried two variations trying to specify the folder for GetOpenFilename.
The first defaults to the directory last used, the second gives me an error message of "Invalid procedure call or argument". I can't use ChDrive "I" because the letter is different for each of my users. Any suggestions? Sub OpenPlacements() ChDir "\\Fl-aejf-fs1\Data\Data\RECOVERY\EXLDATA\Loan Recovery MIS\Placements" Filename = Application.GetOpenFilename("Excel Files (*.xls),*.xls)", , _ "Please choose a Placement file to open", True) End Sub Sub Openplacements2() Dim FileToOpen As Variant Dim MyPath As String Dim Wb As Workbook MyPath = "\\Fl-aejf-fs1\Data\Data\EXLDATA\Loan Recovery MIS\Placements" ChDrive "\\Fl-aejf-fs1\Data\Data" ChDir MyPath FileToOpen = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , _ "Please choose a Placement file to open", , True) If FileToOpen < False Then Set Wb = Workbooks.Open(FileToOpen) Else Exit Sub End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems with ChDrive, ChDir | Excel Programming | |||
ChDir Error | Excel Programming | |||
chdir not accepting string for path | Excel Programming | |||
Links and Chdir | Excel Programming | |||
application.dialogs(xlDialogSaveAs) AND CHDIR | Excel Programming |