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.

Jacobs wrote:
> 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

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
*



Jacobs wrote:
> 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