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
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top