Hey All

Could someone show me a quick way to program two macros. These will be used in Excel to help me automate many of our tasks.
The first one would simply open up an "explorer" window and show only *.foo files. The directory should always point to the same directory everytime it's called. In other words, when I first run the macro I point it to W:\, and every subsequent time after that it points to W:\. Secondly all I want from the file is the Name and Location. I don't want to open the file. Basically a hyperlink to the file, that when depressed would be opened by the default extension. (i.e. .txt -> notepad)
The second Macro would get the Name and Location from the above macro and return the Creation Date and Time. And place that in the cell.

Again thanks so much.



------------------
Steven M. Klass
Physical Design Engineer

Andigilog Inc.
7404 W. Detroit Street, Suite 100
Chandler, AZ 85226
Ph: 602-940-6200 ext. 18
Fax: 602-940-4255

sklass@andigilog.com
http://www.andigilog.com/