Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default Accessing File Properties

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

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default 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
------------------------------------------------------------------------




  #3   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default 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


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

--






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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


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

--








  #5   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default 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


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










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing Attached XLS file shannyshanhan Excel Worksheet Functions 0 August 9th 06 02:57 AM
Accessing document properties of non-Microsoft product files Kevin Beckham Excel Programming 5 November 5th 03 01:36 AM
Accessing custom document properties Tim Haley Excel Programming 2 September 6th 03 02:34 AM
Accessing properties of a series with no data Tom Ogilvy Excel Programming 0 August 1st 03 06:09 PM
Accessing file extensions David P[_3_] Excel Programming 1 July 28th 03 02:52 AM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"