Syntax for AutoCad File Type *.dwg

B

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
 
P

Patrick Molloy

just add another line, you're there already

.FileName = "*.dwg"


Benjamin said:
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top