| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change "Properties" of files
Thx Tom
"NOSPAM" to be removed for direct mailing... *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the file open default permanently to "All files" | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Hybrid Mode
