| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obtain folder names in a excel sheet
Hi all,
i've to write a VB excel macro able to create a list (inside an excel sheet) of specific folders contained in a bigger one. i.e. the "source folder" contains other ones named: Data1 Data2 xml 05.05.06 xml 04.05.06 xml 03.05.06 ....... ........ i would like to obtain just : 05.05.06 04.05.06 03.05.06 in some excel sheet cells thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Obtain folder names in a excel sheet
Check out this thread that shows examples of using the file system
object: http://groups.google.com/group/micro...1fa4e9b1c25dcc You could pretty easily put a line in that says to look for "xml" at the beginning of the folder name. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a macro to include file names in a folder to excel sheet | Excel Discussion (Misc queries) | |||
| how to obtain sheet name? | Excel Discussion (Misc queries) | |||
| Can I insert a file or folder names in Excel cells? | Excel Discussion (Misc queries) | |||
| VBA macro to obtain file names using WIN32 API | Excel Programming | |||
| Change names of files in a folder to match names in Excel Column | Excel Programming | |||
Linear Mode
