Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List files in a directory
Hi Group,
I am trying to get a list of files in the directory c:/Documents and setting/My Documents/TestExcel and open all of them. Thanks, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List files in a directory
Sub FindFiles()
Dim strFile Dim strFolder strFolder = "c:\Documents and setting\My Documents\TestExcel\" strFile = Dir(strFolder & "*.*", vbNormal) Do While strFile < "" Msbgox strFile 'do something strFile = Dir Loop End Sub -- If this post helps click Yes --------------- Jacob Skaria "David" wrote: Hi Group, I am trying to get a list of files in the directory c:/Documents and setting/My Documents/TestExcel and open all of them. Thanks, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List files in a directory
Hi Jacob,
Thank you very much, this is perfect! Sincerely, David "Jacob Skaria" wrote: Sub FindFiles() Dim strFile Dim strFolder strFolder = "c:\Documents and setting\My Documents\TestExcel\" strFile = Dir(strFolder & "*.*", vbNormal) Do While strFile < "" Msbgox strFile 'do something strFile = Dir Loop End Sub -- If this post helps click Yes --------------- Jacob Skaria "David" wrote: Hi Group, I am trying to get a list of files in the directory c:/Documents and setting/My Documents/TestExcel and open all of them. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List all files in a sub directory | Excel Programming | |||
Combo box with list of xls files in a directory | Excel Discussion (Misc queries) | |||
List of Files in A Directory | Excel Discussion (Misc queries) | |||
List Files in a Directory | Excel Programming | |||
Directory List of Excel Files | Excel Programming |