VERY URGENT!!!

Discussion in 'Word VBA Beginners' started by David Schenkler, Aug 8, 2012.

  1. I am extremely new to VBA, but I have been seeing other people's Macros andlearning, but not much.

    I am having a huge problem. I am working with a Requirements Tool that stores all requirement data within itself. In order to export the data into a Word document I needed to create a template that would extract the data and merge it into the Word document correctly.

    With the screen data, I already have a very good template that has very good macros that customize the final document even more. This Macro and template works wonderfully for one screen, but not two or more. Once another screen is added to the report it merges all of the data together instead of allowing the data to go to their separate screens.

    Each screen has Commands, Actions, Variants, Wireframes, Notes, Navigationsand Fields sections.

    I have done much research on this, including contacting the Tool's company to see if there is a way to write the template so that this merge of data does not do this, for which the answer I got was yes, but I would have to copy the template down over and over again in the word document, and be specific for which screens I want.I do not want to do this, because I may want areport of only one screen or I may want a report of fifty screens.

    That's where whoever can help me comes in. I have the belief that Macros can do anything, but I do not know. Does anyone know a way of helping me on this one?

    Thank you so much in advance! You are a life-saver!
    David Schenkler
     
    David Schenkler, Aug 8, 2012
    #1
    1. Advertisements

  2. On Wednesday, August 8, 2012 8:24:42 AM UTC-4, David Schenkler wrote:
    > I am extremely new to VBA, but I have been seeing other people's Macros and learning, but not much.
    >
    >
    >
    > I am having a huge problem. I am working with a Requirements Tool that stores all requirement data within itself. In order to export the data into aWord document I needed to create a template that would extract the data and merge it into the Word document correctly.
    >
    >
    >
    > With the screen data, I already have a very good template that has very good macros that customize the final document even more. This Macro and template works wonderfully for one screen, but not two or more. Once another screen is added to the report it merges all of the data together instead of allowing the data to go to their separate screens.
    >
    >
    >
    > Each screen has Commands, Actions, Variants, Wireframes, Notes, Navigations and Fields sections.
    >
    >
    >
    > I have done much research on this, including contacting the Tool's company to see if there is a way to write the template so that this merge of datadoes not do this, for which the answer I got was yes, but I would have to copy the template down over and over again in the word document, and be specific for which screens I want.I do not want to do this, because I may wanta report of only one screen or I may want a report of fifty screens.
    >
    >
    >
    > That's where whoever can help me comes in. I have the belief that Macros can do anything, but I do not know. Does anyone know a way of helping me onthis one?
    >
    >
    >
    > Thank you so much in advance! You are a life-saver!
    >
    > David Schenkler


    Basically, what I want the Macros to do the following:
    1) Since the template will create the document on many screens anyway, I want the Macros to take the document and separate the screens. Meaning, if I have SCRN-1 and SCRN-2, and I have rich-text, tables, and pictures throughout the document sections pertaining to the both screens, but they were merged together, the Macros will separate all of the information from both screens. This will create a long document with all of the sections of SCRN-1 together, while separately having all of the sections of SCRN-2 together.

    Thank you,
    David Schenkler
     
    David Schenkler, Aug 8, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. vikrampn

    Urgent Help with Word Forms

    vikrampn, Dec 11, 2003, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    85
    Cindy M -WordMVP-
    Dec 19, 2003
  2. Shauna Koppang

    Urgent !- Outlook & Word Integration

    Shauna Koppang, May 27, 2004, in forum: Word VBA Beginners
    Replies:
    3
    Views:
    152
    Jean-Guy Marcil
    May 27, 2004
  3. Shauna Koppang

    Urgent! Further VB Asssitance Word/Outlook Integration

    Shauna Koppang, Jun 1, 2004, in forum: Word VBA Beginners
    Replies:
    13
    Views:
    192
    Jean-Guy Marcil
    Jun 3, 2004
  4. Shauna Koppang

    Urgent Word/Outlook Integration Macro

    Shauna Koppang, Jun 1, 2004, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    124
    Shauna Koppang
    Jun 1, 2004
  5. Adrian

    Project unviewable (urgent if possible)

    Adrian, Jun 29, 2004, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    73
  6. Shauna Koppang

    Urgent! Macro to collect Outlook Address and split

    Shauna Koppang, Jun 29, 2004, in forum: Word VBA Beginners
    Replies:
    2
    Views:
    118
    Charles Kenyon
    Jun 29, 2004
  7. Number to Words (urgent)

    , Feb 11, 2013, in forum: Word VBA Beginners
    Replies:
    0
    Views:
    464
  8. Replies:
    1
    Views:
    414
    Barry Schwarz
    May 9, 2013
Loading...