View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DDawson DDawson is offline
external usenet poster
 
Posts: 59
Default Getting all files of a specific type in a folder

Is there any way to set (and unset) the File Type name through excel VBA?

I want to list all DWG files in a directory and make hyperlinks to them, but
the problem is that different operating systems will use different file type
names e.g. some may be "Autocad 14 Drawing" where AutoCAD version 14 is
installed while others simply "DWG File" where no AutoCAD system is
installed. It would difficult to know what the file type is named as on these
other systems.

Any ideas of a way round this?

Dylan Dawson
Scotland