Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting filenames from a user selected folder
I need to have the user select a folder using msoFileDialogFolderPicker then
get the count and file names of all files in the folder. Please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting filenames from a user selected folder
Why not use the GetOpenFilename method -- Nori ----------------------------------------------------------------------- Norie's Profile: http://www.excelforum.com/member.php...fo&userid=1936 View this thread: http://www.excelforum.com/showthread.php?threadid=37792 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting filenames from a user selected folder
Help with what? If you know you have to use msoFileDialogFolderPicker
you have to know the context in which it makes sense. So, where are you stuck? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I need to have the user select a folder using msoFileDialogFolderPicker then get the count and file names of all files in the folder. Please help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting filenames from a user selected folder
I found a way to accomplish this...
With Application.FileDialog(msoFileDialogFolderPicker) .AllowMultiSelect = False .Show THEpath = .SelectedItems(1) End With With Application.FileSearch .LookIn = THEpath .FileType = msoFileTypeExcelWorkbooks .Execute ALLcount = .FoundFiles.Count For i = 0 To ALLcount - 1 ALLpaths(i) = .FoundFiles(i + 1) Next i End With ----------------- "Mitch" wrote: I need to have the user select a folder using msoFileDialogFolderPicker then get the count and file names of all files in the folder. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
allow user to select folder | Excel Discussion (Misc queries) | |||
Look for a string in filenames in a folder? | Excel Programming | |||
Help with a Macro to list all filenames and mod dates in a folder | Excel Programming | |||
Folder and filenames? | Excel Programming | |||
Changing to a selected folder | Excel Programming |