> Scan While cat = mcat > nRow = nRow + 1 > oRow = oTab.Rows[nRow].Range() > orow.cells[1].range.paragraphformat.linespacing = 10 > Store '' To fblock, line1, line2, line3, line4, line5 > If Empty(stem) && just the responses > line1 = Iif(qstnum < 10,' ' + Alltrim(Str(qstnum)), Alltrim(Str(qstnum))); > + '. a) ' + Alltrim(respa) + CR > line2 = Space(4) + 'b) ' + Alltrim(respb) + CR > line3 = Space(4) + 'c) ' + Alltrim(respc) + CR > line4 = Space(4) + 'd) ' + Alltrim(respd) > Else > line1 = Iif(qstnum < 10,' ' + Alltrim(Str(qstnum)), Alltrim(Str(qstnum))); > + '. ' + Alltrim(stem) + CR > line2 = Space(4) + 'a) ' + Alltrim(respa) + CR > line3 = Space(4) + 'b) ' + Alltrim(respb) + CR > line4 = Space(4) + 'c) ' + Alltrim(respc) + CR > line5 = Space(4) + 'd) ' + Alltrim(respd) > Endif > fblock = line1 + line2 + line3 + line4 + line5 > ** If we've 'run off the page' - time to move to column 2 > ** maxRow holds end of this page row > ** HoldRow holds "next row to print" > ** mCurPage holds current page > If oSec.Range.Information(3) <> mcurpage >wait window "Now Printing page " + alltrim(str(mcurpage)) timeout 3 && This shows for the first 3 pages, after that - no > maxRow = nRow -1 > nRow = HoldRow > mcurpage = oSec.Range.Information(3) > Endif > >>
> If mcat = '40' > oRow = oTab.Rows[nRow].Range() > oRow.Cells.Merge() > oRow.Cells[1].Range.InsertAfter("Directions for items 57-66. " + ; > "You will hear conversations or persons giving information. " + ; > "Select the best answer and mark your answer sheet, a, b, c, or d." + CR) > Endif >>