Thread
:
Query to find last saved date/Time
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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
Reply With Quote