open all books on my hard drive created by me using code(xls

[schultz1414]

How can I search all directories using code,
open all workbooks created by me one at a time,
due so something,
close,
and then proceed to the next.
This message was edited by schultz1414 on 2002-11-01 12:31
This message was edited by schultz1414 on 2002-11-01 12:38

 

[manney]

Assuming you're running Windows in some flavor (3.x through WindowsXP), or Windows NT...

Use the "Find" utility (found in the Start menu).

Search your hard drive -- typically, "C:", but might be additional letters. Search for *.xls

From the list returned, double-click on each file, do your thing, then close it. The search utility will stay active on your system-- see your taskbar-- for you to amuse yourself with the next one.

See any good Windows book ("Windows for Dummies" are very good).

Good luck!