Jim DeMarco
Jdemarco at hudsonhealthplan.org
Fri Feb 13 11:48:50 CST 2004
Patricia, I don't have it handy but I put together an utility app that loops through our network and adds this information to an Access table (A97). Put simply use the Dir command in VBA and then use ADO or DAO to save any found item to the table. If you like I can look for it but it's been quite a while since we've run it and may take some time to find. Jim DeMarco Director Product Development Hudson Health Plan -----Original Message----- From: O'Connor, Patricia [mailto:Patricia.O'Connor at DFA.STATE.NY.US] Sent: Friday, February 13, 2004 12:33 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] OT - file search results save I did a search of one of our server drives for all *.MDB using the Windows 2000 search. Give name of file, directory, size, modify date. Great just what I want, except I can not figure out how to get the results into a file - word, text, excel If I do save results, it puts it into a file but all that seems to do is save the search string. Does anyone know how I can save the listing or have a utility that will allow me to save this in a file. It is probably something simple but I am just getting no where. Thanks Patti _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com