Thread: Cration date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
 
Posts: 147
Default Cration date

ralph wrote:
On Tue, 01 Jan 2013 21:01:10 -0600, witek
wrote:

Does anybody have an idea how to read workbook creation date from
current file using Excel API and C++.

Similar to
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
but using Excel API and C++


Have only seen it done through automation, and have never done it with
Access.
This talks about other office products, but the principle is the same.
http://support.microsoft.com/kb/238393

Roll your C++ code into an ActiveX component (ATL) and call it from
Excel.

If that is all you need, a bit of exploring with a hex editor might
reveal where that property is stored, and with reliable markers a
simple 'file search' might uncover the info. But that is a sheer
guess. I would expect the date to be shrouded a bit in a Date decimal
format.

-ralph


my c++ code is an xll addin.
it must be a direct call to Excel API.
Everything else is too slow for me.
I was looking at xlc... commands and I did not find anything useful but
maybe I missed something.
it is hard to find any documentation.