HOWTO Reference a named cell or range in a script

  • Thread starter Thread starter pwrichcreek
  • Start date Start date
P

pwrichcreek

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
 
Thanks for your reply FSt1.

objExcel.Range("automationFlag") = "Y"

did the trick.

Phil

FSt1 said:
hi
yes. but the syntax would be more like this.

Range("print_Y_or_N") = "Y"

regards
FSt1

pwrichcreek said:
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
Click to expand...
Click to expand...
 
Back
Top