Syntax for AutoCad File Type *.dwg
 

I want to find the syntax for AutoCad file Type *.dwg
That way when my excel file lister will only bring up autocad files into the
spreadsheet.

Please help.

With Application.FileSearch
.LookIn = strSourceFolder 'look in the folder browsed to
.FileType = msoFileTypeAllFiles 'get all files
.SearchSubFolders = False 'don't search sub directories
.Execute 'run the search

Syntax for AutoCad File Type *.dwg
 

just add another line, you're there already

.FileName = "*.dwg"


"Benjamin" wrote in message
...
I want to find the syntax for AutoCad file Type *.dwg
That way when my excel file lister will only bring up autocad files into
the
spreadsheet.

Please help.

With Application.FileSearch
.LookIn = strSourceFolder 'look in the folder browsed to
.FileType = msoFileTypeAllFiles 'get all files
.SearchSubFolders = False 'don't search sub directories
.FileName = "*.dwg"

.Execute 'run the search

Syntax for AutoCad File Type *.dwg
 

You GET A RAISE! THANKS SO MUCH!

"Patrick Molloy" wrote:

just add another line, you're there already

.FileName = "*.dwg"


"Benjamin" wrote in message
...
I want to find the syntax for AutoCad file Type *.dwg
That way when my excel file lister will only bring up autocad files into
the
spreadsheet.

Please help.

With Application.FileSearch
.LookIn = strSourceFolder 'look in the folder browsed to
.FileType = msoFileTypeAllFiles 'get all files
.SearchSubFolders = False 'don't search sub directories
.FileName = "*.dwg"

.Execute 'run the search