Accessing File Properties  
Author Message
BillMannionITManagerGlobalHealth





PostPosted: Fri Feb 13 22:29:07 CST 2004 Top

Excel Programming >> Accessing File Properties

How do I access the "Accessed Date" file property (or any property for
that matter) via VBA?

--
Regards;
Rob
------------------------------------------------------------------------

Excel105  
 
 
Vasant





PostPosted: Fri Feb 13 22:29:07 CST 2004 Top

Excel Programming >> Accessing File Properties Look at the BuiltInDocumentProperties Property of the Workbook Object
(although I don't believe that the Accessed Date is available.

--

Vasant




> How do I access the "Accessed Date" file property (or any property for
> that matter) via VBA?
>
> --
> Regards;
> Rob
> ------------------------------------------------------------------------
>
>


 
 
RWN





PostPosted: Fri Feb 13 22:42:40 CST 2004 Top

Excel Programming >> Accessing File Properties Thanks (and I think you're right), but I should have been more specific.
What I want to do is to find the Accessed Date for any file of my
choosing.
--
Regards;
Rob
------------------------------------------------------------------------


> Look at the BuiltInDocumentProperties Property of the Workbook Object
> (although I don't believe that the Accessed Date is available.
>
> --
>
> Vasant
>
>


> > How do I access the "Accessed Date" file property (or any property
for
> > that matter) via VBA?
> >
> > --
> > Regards;
> > Rob
>
> ----------------------------------------------------------------------
--
> >
> >
>
>


 
 
Tom





PostPosted: Sat Feb 14 08:19:19 CST 2004 Top

Excel Programming >> Accessing File Properties See this posting by Ole Erlandsen:

http://groups.google.com/groups?selm=umuohruc%24GA.266%40cppssbbsa05

--
Regards,
Tom Ogilvy




> Thanks (and I think you're right), but I should have been more specific.
> What I want to do is to find the Accessed Date for any file of my
> choosing.
> --
> Regards;
> Rob
> ------------------------------------------------------------------------


> > Look at the BuiltInDocumentProperties Property of the Workbook Object
> > (although I don't believe that the Accessed Date is available.
> >
> > --
> >
> > Vasant
> >
> >


> > > How do I access the "Accessed Date" file property (or any property
> for
> > > that matter) via VBA?
> > >
> > > --
> > > Regards;
> > > Rob
> >
> > ----------------------------------------------------------------------
> --
> > >
> > >
> >
> >
>
>


 
 
RWN





PostPosted: Sat Feb 14 19:39:17 CST 2004 Top

Excel Programming >> Accessing File Properties Thanks a lot (forgot about the scripting runtime library:-))

--
Regards;
Rob
------------------------------------------------------------------------


> See this posting by Ole Erlandsen:
>
> http://groups.google.com/groups?selm=umuohruc%24GA.266%40cppssbbsa05
>
> --
> Regards,
> Tom Ogilvy
>
>


> > Thanks (and I think you're right), but I should have been more
specific.
> > What I want to do is to find the Accessed Date for any file of my
> > choosing.
> > --
> > Regards;
> > Rob
>
> ----------------------------------------------------------------------
--


> > > Look at the BuiltInDocumentProperties Property of the Workbook
Object
> > > (although I don't believe that the Accessed Date is available.
> > >
> > > --
> > >
> > > Vasant
> > >
> > >


> > > > How do I access the "Accessed Date" file property (or any
property
> > for
> > > > that matter) via VBA?
> > > >
> > > > --
> > > > Regards;
> > > > Rob
> > >
> >
> ----------------------------------------------------------------------
> > --
> > > >
> > > >
> > >
> > >
> >
> >
>
>