Hi,

I just read the postings of getting the file properties of a opened
workbook. I'd like to know if it is possible (eg via API) to get the file
properties of a CLOSED file.

I have a zipped file on my website which my clients can download. However,
in Windows WP, it decompresses automatically, in versions before it doesn't.
I could look at the file size but this changes time to time. If I look to
the document properties, the extracted file contains my properties (eg.
title of my program) but the compressed file doesn't. If I could read only
one property, I could see if I get the compressed or extracted file.

Any help is appreciated!
Thanks
Jos Vens

Jos,

See the "Document Properties of Close Files" at
http://www.cpearson.com/excel/docprop.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jos Vens" wrote in message
...
Hi,

I just read the postings of getting the file properties of a
opened
workbook. I'd like to know if it is possible (eg via API) to
get the file
properties of a CLOSED file.

I have a zipped file on my website which my clients can
download. However,
in Windows WP, it decompresses automatically, in versions
before it doesn't.
I could look at the file size but this changes time to time.
If I look to
the document properties, the extracted file contains my
properties (eg.
title of my program) but the compressed file doesn't. If I
could read only
one property, I could see if I get the compressed or extracted
file.

Any help is appreciated!
Thanks
Jos Vens

Hi Chip,

thanks, but this is no compromise for me. I can't ask to my customers to
set this reference on. I have now solved the problem by setting the
attribute of the zipped file to read only and the attribute of the unzipped
is read/write. So if XP unzips, i have an attribute of 32 (GetAttr in VBA),
if it is more (33) it is zipped. Is my way of thinking correct?

Thanks
Jos

"Chip Pearson" schreef in bericht
...
Jos,

See the "Document Properties of Close Files" at
http://www.cpearson.com/excel/docprop.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jos Vens" wrote in message
...
Hi,

I just read the postings of getting the file properties of a
opened
workbook. I'd like to know if it is possible (eg via API) to
get the file
properties of a CLOSED file.

I have a zipped file on my website which my clients can
download. However,
in Windows WP, it decompresses automatically, in versions
before it doesn't.
I could look at the file size but this changes time to time.
If I look to
the document properties, the extracted file contains my
properties (eg.
title of my program) but the compressed file doesn't. If I
could read only
one property, I could see if I get the compressed or extracted
file.

Any help is appreciated!
Thanks
Jos Vens