Syntax for AutoCad File Type *.dwg

[Benjamin]

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

 

[Patrick Molloy]

just add another line, you're there already

.FileName = "*.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

.FileName = "*.dwg"

 

[Benjamin]

You GET A RAISE! THANKS SO MUCH!

just add another line, you're there already

.FileName = "*.dwg"



.FileName = "*.dwg"