borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (DDEInitiate - Excel - VB)Next Topic (export ms access to ms excel sheet) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Need to copy values from other documents based on heading name and create a new document through VBA
Poster Message
itchock
Level: Trainee

Registered: 14-09-2006
Posts: 1

icon Need to copy values 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.

14-09-2006 at 09:16 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : Need to copy values from other documents based on heading name and create a new document through VBA
Previous Topic (DDEInitiate - Excel - VB)Next Topic (export ms access to ms excel sheet) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder