TheSwamp
Code Red => VB(A) => Topic started by: orcan on September 25, 2014, 03:03:22 AM
-
Hi all
The code for searching files with excel vba "Application.FileSearch" seems like disabled in excel 2010.
I have .dwg file names on my excel list and i need to open them with autocad by searching and finding them through my
harddisc.
İs there an alternative way for this in excel 2010.
Thanks in advance.
-
you could use the "Dir" function
jusr type "Dir" in your IDE, place your cursor inbetween its letters and press F1 to make online Excel VBA guide's pertinent topic appear with examples, too
you can also see its use in "TotalLenght.xlm" I attached in reply#5 of http://www.theswamp.org/index.php?topic=47844.0 (http://www.theswamp.org/index.php?topic=47844.0)