View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Query to find last saved date/Time

This is no job for MSQUERY

Since you are in an EXCEL NG, use VBA.
Look at FilesSearch in Help

HTH
--
AP

"Dean" a écrit dans le message de news:
...
I want to run an MSQuery on all the spreadsheets on my network drive, to
find
when they were last modified/accessed!

Would it be possible in MSQuery or easier in VB?
Can anyone suggest a way to do it?

Thanks
Dean