View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default 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