Need to copy Paragraphs from other documents based on heading name and create a new document through VBA  
Author Message
Chocks





PostPosted: Visual Basic for Applications (VBA), Need to copy Paragraphs from other documents based on heading name and create a new document through VBA Top


Need to copy Paragraphs from other documents based on heading name and create a new document through VBA
Hi,
I my company i am working for a Department. This Department has 4 Divisions. Each Division will send their Weekly Highlights to My Department. I will select important topics from the 4 Word Documents which i recieved from Division and i place it in a new Document, this new document wil be send to the management.
For example Each Division has a Heading named
'Productivity & Improvement And Cost Savings'
'HRD22 Gain'
under that they may have a heading containing the word 'HRD22 Gain' like this. So i have to pick all the paragraph which contains the word 'Gain' in their heading which come under 'Productivity & Improvement And Cost Savings'. Similar to the Example i said i have some more headings and some more sub headings which i have to do.
Every week i am doing this repeated process. I like to automate this. Is it possible to write VBA code. Where i can get a similar example or forum which could guide me.
I think when i open a new document and run the macro - all the required headings & paragraphs will copied from the four divisions will be pasted in this newly opened document. The code should do this or any other suggestions please.
Thanks,
Chock.



Microsoft ISV Community Center Forums1