#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
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
File Properties TerryTutor Excel Discussion (Misc queries) 2 August 30th 07 06:06 PM
File Properties Frozen Odie Excel Discussion (Misc queries) 3 March 1st 07 08:17 PM
File Properties ALEX Excel Discussion (Misc queries) 1 February 8th 07 02:47 PM
File Properties Annie Excel Discussion (Misc queries) 1 April 20th 06 08:27 PM
File Properties Andrew Excel Discussion (Misc queries) 2 August 19th 05 01:23 PM


All times are GMT +1. The time now is 09:57 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"