ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Accessing File Properties (https://www.excelbanter.com/excel-programming/291371-accessing-file-properties.html)

RWN

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

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



Vasant Nanavati

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

--

Vasant


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

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





RWN

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
------------------------------------------------------------------------
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Look at the BuiltInDocumentProperties Property of the Workbook Object
(although I don't believe that the Accessed Date is available.

--

Vasant


"RWN" wrote in message
...
How do I access the "Accessed Date" file property (or any property

for
that matter) via VBA?

--
Regards;
Rob


----------------------------------------------------------------------

--







Tom Ogilvy

Accessing File Properties
 
See this posting by Ole Erlandsen:

http://groups.google.com/groups?selm...%40cppssbbsa05

--
Regards,
Tom Ogilvy


RWN wrote in message
...
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
------------------------------------------------------------------------
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Look at the BuiltInDocumentProperties Property of the Workbook Object
(although I don't believe that the Accessed Date is available.

--

Vasant


"RWN" wrote in message
...
How do I access the "Accessed Date" file property (or any property

for
that matter) via VBA?

--
Regards;
Rob


----------------------------------------------------------------------

--









RWN

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

--
Regards;
Rob
------------------------------------------------------------------------
"Tom Ogilvy" wrote in message
...
See this posting by Ole Erlandsen:

http://groups.google.com/groups?selm...%40cppssbbsa05

--
Regards,
Tom Ogilvy


RWN wrote in message
...
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


----------------------------------------------------------------------

--
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Look at the BuiltInDocumentProperties Property of the Workbook

Object
(although I don't believe that the Accessed Date is available.

--

Vasant


"RWN" wrote in message
...
How do I access the "Accessed Date" file property (or any

property
for
that matter) via VBA?

--
Regards;
Rob


----------------------------------------------------------------------
--












All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com