| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba browse button set to current directory
I am working with a form with browse buttons to load a file from a
certain directory; I would like for that directory to be the one that holds the currently open excel/vba form. Currently, I am using curdir and getting the 'default' storage location set up in Excel (MyDocuments..). '============= Dim SaveDriveDir As String SaveDriveDir = CurDir() MsgBox (CurDir) ChDir (SaveDriveDir) NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file") '=============== Thanks for any help in this, Louis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change current directory to the directory that the workbook loads from! | Excel Programming | |||
| directory browse... | Excel Programming | |||
| Directory Browse/Search information | Excel Programming | |||
| changing current directory to that of the current open file | Excel Programming | |||
| Browse For Folder start directory | Excel Programming | |||
Threaded Mode
