| T O P I C R E V I E W |
| JOSAMUEL |
Posted - 07/23/2021 : 1:48:30 PM
Hi all,
I have 10 workbooks for example in a project with the workbooks named as 1 till 10. Now I need to add a column in all of the 10 workbooks. However, when I'm adding, the column added in the workbook named 1 should have the number 1 in all the rows, and the column added for the workbook named 2, should contain the number 2 in all the rows. likewise, it should go on until file 10th file. Any idea how to do this?
Thanks in advance.
JOSAMUEL |
| 1 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 07/23/2021 : 6:11:54 PM
I suppose you mean book long names are 1 to 10 since book short names can't start with number.
Then suppose you only have 1 sheet in book, try this
doc -e W {
book$ = page.longname$;
wks.ncols=wks.ncols+1;
csetvalue col:=$(wks.ncols) formula:=book$;
}
Thanks, Snow |
|
|
