Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Properties | Excel Discussion (Misc queries) | |||
File Properties Frozen | Excel Discussion (Misc queries) | |||
File Properties | Excel Discussion (Misc queries) | |||
File Properties | Excel Discussion (Misc queries) | |||
File Properties | Excel Discussion (Misc queries) |