Category : Tutorials + Patches
Archive   : QPRODOC.ZIP
Filename : TI665.ASC

 
Output of file : TI665.ASC contained in archive : QPRODOC.ZIP







PRODUCT : Quattro Pro NUMBER : 665
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 1/3

TITLE : Development Macro For Assigning Block Names




Once you have gone through the efforts of creating a spreadsheet
template or a macro, you must decide the best method for sharing
your work with others, and vice verse. You have the options of
providing the spreadsheet on a disk or in a printed format. When
time is crucial, supplying the file on a disk is not practical.
Since the introduction of FAX machines, a hard-copy can be
provided to the user at a minutes notice. However, the user must
replicate your work from this printout.

Replicating a template or macro from a printed copy can be easily
accomplished, especially if Quattro Pro's Cell-Formulas print
option was used to create the printout. The catch is accurately
generating the block names associated to various cells within
your work. The best way to ensure that the block names are
assigned to the correct cells is to provide a table of block
names using /Edit | Names | Make Table. The drawback to this
method is that it takes time to replicate these block names.

This sheet introduces a development macro that will access a
table of block names and cell addresses and assign names as
requested. All you need to do is enter the table along with the
macro into a macro library file and the macro will execute on any
spreadsheet.

To use this macro, enter the commands outlined below and define a
data table. The table must contain at least three columns. In
the first column, enter the name to be assigned to the cell, or
cells. The second column of the table must contain a cell
address or block range that corresponds to the cells to be
assigned to the name in the first column. The third column of
the table should be left blank. If a block range in the table
contains ERR, "XXX" will be placed in the third column, alerting
you to the failure of naming the block. Assign the name _table
to the data table.

Once the macro has been entered and the data table has been
created, open the spreadsheet that is to accept the block names
and press . The macro will create each name within the
table in the current spreadsheet.

















PRODUCT : Quattro Pro NUMBER : 665
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 2/3

TITLE : Development Macro For Assigning Block Names




Creating the macro

To create the macro, begin by assigning the block names:

_count B13
_table B14..D14

Use /Edit | Names | Create to assign the appropriate names to the
designated cells. Don't be concerned with placing data into
_table at this time. The name is necessary for entering the
macro into the spreadsheet.

Continue entering the macro commands as shown below. Make sure
the entries in cells B6 and B8 are entered as formulas and not
values.

A B
|-------------------------
1 | \N {FOR _count,0,@ROWS(_table)-1,1,_CREATE}
2 |
3 | _CREATE {RECALC _CREATE}
4 | {IF @INDEX(_table,1,_count)="ERR"}{BRANCH _ERR}
5 | {/ Name;Create}
6 | @INDEX(_table,0,_count) <- formula
7 | ~
8 | @INDEX(_table,1,_count) <- formula
9 | ~
10 |
11 | _ERR {PUT _table,2,_count,XXX}{RETURN}
12 |
13 | _count
14 | _table

Once all commands have been entered, define the remaining block
names:

\N B1
_CREATE B3..B9
_ERR B11

This will complete the naming process for the macro. To complete
the macro, select /Tools | Macro | Library | Yes and save the
spreadsheet. The macro is now ready for use.













PRODUCT : Quattro Pro NUMBER : 665
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 3/3

TITLE : Development Macro For Assigning Block Names




Example Data Table

\P B5
_CT B19
_JUNK ERR

NOTE: Make sure to expand _table to include all rows containing
print information.











































  3 Responses to “Category : Tutorials + Patches
Archive   : QPRODOC.ZIP
Filename : TI665.ASC

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/