Change meta data for many documents at once

Hi guys,

Im wondering if its possible to have vba change the meta data for many documents?

The only way I can think of, is if I have excel open every word document, excel and pdf, make changes and save and close. And im a bit worried about doing that approximately 2000 times in one macro.
I'd imagine it would take a very long time, unless someone knows a few tricks.


I don't think I would be able to get excel to update .jpeg metadata like EXIF information


I'm wondering if anyone knows a better way to do this or has some ideas?

Thanks,
Jimmy

Here's a recent mass replacement:

Please Login or Register  to view this content.

to replace all instances of 123Foo with 123Foobar - it's as good as new, only dropped once

Hi xladept,

I'll play around with it, but I don't think that would work for word and pdf or other types of files.

Please Login or Register  to view this content.

Don't you mean workbooks? Because the properties within a book's worksheets will all be the same..

From what I can tell, that would only work with workbooks, what about pdf's and word documents?

Thanks,

Hi Jimmy,

No, it's worksheets, just as written. And, yes, it's good for just the excel

Is there a way to do it for PDFs and other types of documents?

vba>tools>references...>Adobe? etc

thanks

Also, I'm hoping to do this to many files, not just the few that are open.

I'll have a look and play around with your idea soon.

On both Word and PDF, by googling, they suggest that you convert the PDF to Word and then back to PDF.

Do you have Adobe? I don't

And I haven't got the code for the Word conversion although the VBA is similar the naming is strange to me

word vba is a bit different, messes things up a bit.

what I have for word, almost works, except it doesn't because read and write permissions. kinda works if you use a template document, but even then it's opening changing, saving and closing documents. I was hoping there was a way of doing it with the shell or something?

Below is what I've got for word:

Module1:

Please Login or Register  to view this content.

ClassModules:

Please Login or Register  to view this content.

This Document

Please Login or Register  to view this content.

I wonder whether events are the way to go - not what I envisioned

*Bumping*

Still looking for a good method to do this.
Thanks,
Jimmy