Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file chooser
I want users to be able to specify the directory where their files are
located. I manipulate a number of files, one person might have them under c:\mydata, another might store them f:\test. Is there such a control in Excel? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
file chooser
This might be what you are looking for:
Sub dk() Wb = Application.Dialogs(xlDialogOpen).Show MsgBox ActiveWorkbook.Name End Sub You can use the "previous" icon in the dialog box to walk back up the directory chain. "Diana" wrote in message ... I want users to be able to specify the directory where their files are located. I manipulate a number of files, one person might have them under c:\mydata, another might store them f:\test. Is there such a control in Excel? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
file chooser
If you are looking for a folder picker then try
Sub Macro() Dim strFolder As String With Application.FileDialog(msoFileDialogFolderPicker) .AllowMultiSelect = False If .Show = -1 Then strFolder = .SelectedItems(1) Else MsgBox "No folder selected" End If End With End Sub -- Jacob "Diana" wrote: I want users to be able to specify the directory where their files are located. I manipulate a number of files, one person might have them under c:\mydata, another might store them f:\test. Is there such a control in Excel? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use Calender control as date chooser in excel?? | Excel Discussion (Misc queries) | |||
How to setup a 'chooser' box/cell for Y or No? | Excel Discussion (Misc queries) | |||
Formula chooser? | Excel Worksheet Functions | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) | |||
GUI like the file chooser | Excel Programming |