Change "Properties" of files
 

Hi There,

I am wondering whether it is possible to change the info of a file
through VBA.
= File=Properties=Summary
And then changing the info of:

Title:
Subject:
Author:
Manager:
Company:

Category:
Keywords:
Comments:

Actually this info should be changed on all (25 daily!) the files in a
specified folder.

Anyone an idea?
Sige

Change "Properties" of files
 

Look in help at the BuildInDocumentProperties object.

Sample code at Chip Pearson's site:
http://www.cpearson.com/excel/docprop.htm

--
Regards,
Tom Ogilvy


"Sige" wrote in message
ups.com...
Hi There,

I am wondering whether it is possible to change the info of a file
through VBA.
= File=Properties=Summary
And then changing the info of:

Title:
Subject:
Author:
Manager:
Company:

Category:
Keywords:
Comments:

Actually this info should be changed on all (25 daily!) the files in a
specified folder.

Anyone an idea?
Sige

Change "Properties" of files
 

Thx Tom

"NOSPAM" to be removed for direct mailing...

*** Sent via Developersdex http://www.developersdex.com ***

Change "Properties" of files
 

Look in help at the BuildInDocumentProperties object.

Build should be Built


--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Look in help at the BuildInDocumentProperties object.

Sample code at Chip Pearson's site:
http://www.cpearson.com/excel/docprop.htm

--
Regards,
Tom Ogilvy


"Sige" wrote in message
ups.com...
Hi There,

I am wondering whether it is possible to change the info of a file
through VBA.
= File=Properties=Summary
And then changing the info of:

Title:
Subject:
Author:
Manager:
Company:

Category:
Keywords:
Comments:

Actually this info should be changed on all (25 daily!) the files in a
specified folder.

Anyone an idea?
Sige