Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SelectedItems
Hi All,
I'd like to use in XL2003 With Application.FileDialog(msoFileDialogFolderPicker) .Show to select a folder. Pressing OK works, .SelectedItems(1) returns the name of the selected folder. How can I deal with pressing Cancel? I tried If .SelectedItems(1) = "" Then and If .SelectedItems(1) is Nothing Then but with no success. Thanks, Stefi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SelectedItems
Sorry again, now I know the answer:
If .Show = 0 Then Stefi €žStefi€ť ezt Ă*rta: Hi All, I'd like to use in XL2003 With Application.FileDialog(msoFileDialogFolderPicker) .Show to select a folder. Pressing OK works, .SelectedItems(1) returns the name of the selected folder. How can I deal with pressing Cancel? I tried If .SelectedItems(1) = "" Then and If .SelectedItems(1) is Nothing Then but with no success. Thanks, Stefi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SelectedItems
if .Show = False Then 'User Clicked Cancel
Stefi wrote: Hi All, I'd like to use in XL2003 With Application.FileDialog(msoFileDialogFolderPicker) .Show to select a folder. Pressing OK works, .SelectedItems(1) returns the name of the selected folder. How can I deal with pressing Cancel? I tried If .SelectedItems(1) = "" Then and If .SelectedItems(1) is Nothing Then but with no success. Thanks, Stefi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filedialog selecteditems driving me crazy | Excel Programming |