UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Command Line Syntax To Print List With Date Modified, office 2013    
 
   
bakersburg9
post Oct 3 2018, 12:40 PM
Post#1



Posts: 5,230
Joined: 2-November 04
From: Downey, CA


I want to print a list of files in a directory with the last modified date, but having a problem with the right syntax

This just prints a list of excel files with .xls extension

CODE
dir *.xls /b>ListOnlyExcelFiles.txt


I found that this will DISPLAY on the screen the last modified date:

dir /TW

... but how do I incorporate that in my command line ?
Go to the top of the page
 
theDBguy
post Oct 3 2018, 12:53 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,472
Joined: 19-June 07
From: SunnySandyEggo


Hi Steve,

Just curious... Why are you trying to use a DOS Command instead of VBScript or PowerShell or even VBA or FSO?

What is the setup? Where are you trying to execute this command? etc.

Just wondering...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 3 2018, 03:03 PM
Post#3



Posts: 5,230
Joined: 2-November 04
From: Downey, CA


dbGuy,
I've only used VBScript to open and copy files... have no experience with Power Shell - hard to explain my set up - I get Excel files that I need to work on, and they are dumped in a folder on the Network for my company - I want to easily print a list of the files, and it would be helpful to have the date modified, etc.

but it would be great to use VBscript, so I could just save it on my desktop, and click it!

Steve
Go to the top of the page
 
theDBguy
post Oct 3 2018, 03:08 PM
Post#4


Access Wiki and Forums Moderator
Posts: 73,472
Joined: 19-June 07
From: SunnySandyEggo


Hi Steve,

Are you opposed to using Access/VBA? If not, take a look at my ListFiles demo on my website and see if you could modify it to include the information you need.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 3 2018, 03:22 PM
Post#5



Posts: 5,230
Joined: 2-November 04
From: Downey, CA


I'll check it later - very impressive site, WOW !

EDIT: in researching this stuff on the web, I found a little thing about even being able to find out when a file was ACCESSED ! That's interesting... all the years I've been working with computers, I've always only thought of Date Created, Date Modified, that's pretty much it ...

Steve
This post has been edited by bakersburg9: Oct 3 2018, 03:29 PM
Go to the top of the page
 
theDBguy
post Oct 3 2018, 03:33 PM
Post#6


Access Wiki and Forums Moderator
Posts: 73,472
Joined: 19-June 07
From: SunnySandyEggo


Hi Steve,

While you're there, there's another demo to get the extended file attributes. I don't remember if it includes "last access" but just thought you might check it out as well.

Good luck!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 3 2018, 03:44 PM
Post#7



Posts: 5,230
Joined: 2-November 04
From: Downey, CA


Thanks!

yeah, according to what I discovered, dir /TA shows last accessed
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th October 2018 - 09:58 PM