File Properties in Macros

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Is it possible to retrieve the file properties for the
file of the current worksheet in a XL 2000 macro? I can
view them interactively (File|Properties|Statistics) but
don't know how to obtain it in a macro. Am particularly
interested in the last-saved datestamp.

Thx.
 
SaveDateTime = FileDateTime(ThisWorkbook.Path & "\" & ThisWorkbook.Name
 
You must log in or register to reply here.

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

Similar Threads

Call macro in other sheet 6
macro to show File Comments property 5
Macro to use information in a cell to locate and send files using outlook 0
Referencing a cell value in a macro 7
including macro in protected worksheet 2
Do not undesratnd the error when calling EXcel macro from .vbs script 2
MRound 7
Lose macros before saving 4

Back
Top