Results 1 to 4 of 4
  1. #1
    msgunasekaran is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Oct 2019
    Posts
    2

    Need help to create word macro

    Hi All,

    I creating word macro for my personal use. I have below queries. Can some one help me this.

    I have word document contains few key words in [] like below:



    SQ01.In the past 30 days, have you participated in a market research study related to any of the following?

    (Please select all that apply)

    [RANDOMIZE]


    1. Target Temperature Management [THANK AND TERMINATE]
    2. Vascular Access
    3. Drug Excretion
    4. Pain Management
    5. Insulin Therapy

    98. None of the above[EXCLUSIVE]

    Below is my questions:
    1) In above format I need to replace SQ01 into one question like <radio label="SQ01">questiontext</radio>
    2) Then numbers list (1 to 5 and 98) should be convert into <row label="r1">list text</row>
    3) If I find in below question (Please select all that apply) then it should be <comment></comment>

    So above question result should be like below:
    <radio label="SQ01">In the past 30 days, have you participated in a market research study related to any of the following?</radio>
    <comment>(Please select all that apply)</comment>
    <row label="r1">Target Temperature Management<row>
    <row label="r2">Vascular Access<row>
    <row label="r3">Drug Excretion<row>
    <row label="r4">Pain Management<row>
    <row label="r5">Insulin Therapy<row>
    <row label="r98">None of the above<row>

    I need to this in full word document, can some one help me on this.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    at this point, 48 views and no replies. Maybe because we're not Word experts for the most part. Why post here in an Access forum for such a Word problem??

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with micron --lot's of views, no responses. The forum is geared to Access and vba, limited Excel, and not much Word, Powerpoint.....
    I did a search and found this link. I hope it means more to you than it does me.

    I have taken boiler plate text and replaced names, addresses, subject, article references etc.
    It wasn't word, it was Access reading and replacing into a text file.
    I used markers within the text eg $#custname$# where $# or something equivalent marked the start and end of the marker to be replaced. The $# was something not found in the "real text".
    You might find more focused info on youtube.
    Good luck with your project.

  4. #4
    msgunasekaran is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Oct 2019
    Posts
    2
    Thanks Orange!

    I will do more analyze and let you know if anything else.

    -Guna

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-23-2017, 07:34 AM
  2. Hyperlink to macro-enabled Word is unpredictable
    By sheila.moore in forum Forms
    Replies: 15
    Last Post: 11-16-2015, 01:01 PM
  3. Macro Word Mail Merge
    By jopi in forum Macros
    Replies: 2
    Last Post: 06-15-2014, 12:28 PM
  4. Replies: 3
    Last Post: 05-22-2014, 09:23 AM
  5. Access / Excel / Word Checkbox Macro Inquiry
    By taikuodo in forum Programming
    Replies: 0
    Last Post: 06-04-2012, 06:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums