Can a macro be created to keep a list of files created by a user

J

Jacobs

I would like to create a macro do the following:
When I create a document, then I close a document, whether it be in Excel or
in Word, it captures the file name and path, then puts it in a dedicated
document, so that if asked about a file that I created I can look and see the
file name and path, and maybe even the date.

Is this possible

Rebecca
 
M

ManningFan

Is it possible? Yes.

Can a Newbie do it? Not likely. It's pretty complex to start pulling
filename, filepath and filedates out of your computer. Doing it
cross-object (i.e. tracking Excel and Word changes from Access) is
nearly impossible unless you're shelling out from Access.
 
S

strive4peace

Hi Rebecca,

yes, you can do this... but why? you can search on files using Windows
Explorer or My Computer...

If you have the view ( Windows Explorer or My Computer) set to details
(which is what I like to do), you will see:

Name, Size, Type, Date Modified, ... and you can customize the columns
to show more...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top