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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
*
 
Back
Top