Author Topic: How to Search for a File on Excel 2010  (Read 3464 times)

0 Members and 1 Guest are viewing this topic.

orcan

  • Guest
How to Search for a File on Excel 2010
« 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.

RICVBA

  • Newt
  • Posts: 62
Re: How to Search for a File on Excel 2010
« Reply #1 on: September 25, 2014, 05:44:37 AM »
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