ALIMS
05-29-2013, 08:42 AM
:banghead: After scouring the web searching for a solution to help automate what could be defined as the “7th circle of repetition hell” :devil2: , I came across this site and found some very hopeful posts by some of your members and am hoping that I can gain some help with my project.
My problem lies in how to make changes to individual lines contained within multiple blocks of formatted text. Here is an example:
SPAD-6000-ADMN [N/A] N/A N/A B N/A C N/A Times: 1
TEC. N/A
Task. Completed all 2000-4000 level tasks.
Requirement. N/A
Performance Standard. Completed all 2000-4000 level tasks.
Prerequisites. N/A
External Syllabus Support. N/A
Academics:
References. N/A
Lectures. N/A
IMIs. N/A
Exams. N/A
T&R Task Sign-Off Authority. Work Center Supervisor
The standard formatting options for ALL blocks as shown above is:
1. font: courier new 10 point
2. Line spacing options: 6 points before and 0 points after
3. Each line set to 1 inch margin.
4. Each line has a heading, which should be underlined (minus the period or the colon after Academics).
5. Each heading should end with a period (or a colon in the case of academics) and be preceded with TWO spaces.
What is the best recommendation to create a macro that will loop through each block of text, check the various formatting as listed above and make corrections where necessary? I am by no means a “programmer”, so some of the object oriented terms and techniques on the Microsoft Developer forums tend to get lost in translation. I have more of a procedural understanding of how to accomplish automated tasks such as this. I have collected a few macro “gems” but am unable to cobble them together to create something that I can understand, extend and modify.
Any assistance would be greatly appreciated. :help
My problem lies in how to make changes to individual lines contained within multiple blocks of formatted text. Here is an example:
SPAD-6000-ADMN [N/A] N/A N/A B N/A C N/A Times: 1
TEC. N/A
Task. Completed all 2000-4000 level tasks.
Requirement. N/A
Performance Standard. Completed all 2000-4000 level tasks.
Prerequisites. N/A
External Syllabus Support. N/A
Academics:
References. N/A
Lectures. N/A
IMIs. N/A
Exams. N/A
T&R Task Sign-Off Authority. Work Center Supervisor
The standard formatting options for ALL blocks as shown above is:
1. font: courier new 10 point
2. Line spacing options: 6 points before and 0 points after
3. Each line set to 1 inch margin.
4. Each line has a heading, which should be underlined (minus the period or the colon after Academics).
5. Each heading should end with a period (or a colon in the case of academics) and be preceded with TWO spaces.
What is the best recommendation to create a macro that will loop through each block of text, check the various formatting as listed above and make corrections where necessary? I am by no means a “programmer”, so some of the object oriented terms and techniques on the Microsoft Developer forums tend to get lost in translation. I have more of a procedural understanding of how to accomplish automated tasks such as this. I have collected a few macro “gems” but am unable to cobble them together to create something that I can understand, extend and modify.
Any assistance would be greatly appreciated. :help