ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   File properties (https://www.excelbanter.com/excel-worksheet-functions/169124-file-properties.html)

Radek Simek[_2_]

File properties
 
Hi,

I have the following problem and don't know how to handle it. It might be
partially connected to SAP. Can anyone help?

I get export from customized SAP interface as a set of data in Excel. I need
to find out date of file creation so that I can count days from start of some
activity until the export day. I use macro function
BuiltinDocumentProperties. Unfortunatelly this gives me incorrect result.
When I display file properties in Windows explorer, it is 10.12.2007, but the
macro function returns 28.10.1999. Can this be any Excel error of the
respective function? The other option is that the date 28.10.1999 is somehow
set in SAP as default date of any export (this happens only for this for this
respective report even if generated in different times).

So my major question is if the BuiltinDocumentProperties function works fine
or if you have experienced any issues with it?

Thanks for any help.
Radek


All times are GMT +1. The time now is 06:00 AM.

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