July 5, 2009 05:14pm pdt

1. matthews... 251,736
2. brettdj 217,368
3. BlueDevilF... 183,540
4. rorya 175,867
5. chris_bot... 171,166
6. saurabh726 146,122
7. war1 100,282
8. barryhou... 90,908
9. patrickab 82,700
10. GrahamSkan 80,800
11. JOrzech 80,475
12. redrumkev 76,955
13. apache09 67,595
14. tbsgadi 58,000
15. dlc110... 57,550
16. pari123 56,270
17. ahammar 52,700
18. boag2000 45,254
19. Mestha 42,680
20. DatabaseMX 41,414
21. capricorn1 40,993
22. cool_sat... 40,655
23. Echo_S 37,250
24. jppinto 35,600
25. byundt 30,572

1. bruintje 1,641,436
2. matthews... 990,980
3. byundt 867,212
4. rorya 572,108
5. war1 517,500
6. brettdj 478,817
7. GrahamSkan 458,428
8. saurabh726 449,123
9. zorvek 425,632
10. ture 388,739
11. BlueDevilF... 386,206
12. Dreamboat 369,995
13. chris_bot... 348,503
14. calacuccia 340,042
15. cri 322,938
16. ahammar 254,617
17. KCTS 247,539
18. JOrzech 228,324
19. patrickab 211,278
20. smozgur 205,366
21. antrat 197,847
22. redrumkev 174,705
23. p912s 161,798
24. sebastienm 155,935
25. R_Rajesh 151,140

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

07/05/2001 at 08:54AM PDT, ID: 20146327

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.0

Word-VBA-read file & write to properties

Asked by rdmjrb in Microsoft Office Suite

Tags: vba, file, read, word

Hello,

I have a project that needs to do the following once a quarter and will involve 200+ documents each time so I'm looking for a semi-portable solution.
1. Set the document properties in a standardized fashion.

Each document follows a strict template so I will be able to open the file, "scrape" the data I need, re-format it for the properties, set the new properties, save and close the file.

I propose the following using VBA code:
(simplified for brevity)
1. open the file
2. do a search in the file for a person's name (Instr, Mid, etc.) (always located in the same place)
3. re-format the name (Last, First M.) set that name into the title property
4. save file
5. close file

I'm looking for specific code and am open to a whole new proccess, this is what i've come up with so far....

cheers!View the Solution FREE for 30 Days

20090624-EE-VQP-63

Word-VBA-read file & write to properties

Asked by rdmjrb in Microsoft Office Suite

Tags: vba, file, read, word

About this solution