HOWTO Reference a named cell or range in a script
In a windows script I have the following statement to put a value
into a worksheet that I have opened in the script:
objExcel.Cells(1, 1).Value = "y"
If I assign a name to cell 1,1 in EXCEL -- say for example print_Y_or_N --
can I then refer to cell 1,1 (in the script) using that name? Sortof like you
could in a VBA macro, like
[print_Y_or_N] = "y"
I think using a name instead of hard-coded cell cooridnate improves
maintainability. Doesn't it?
TIA,
Phil
|