[Solved] Writing string to a cell
Posted: Wed Feb 28, 2018 10:46 am
Hi All,
I am writing data into a cell with the following commands:
If I assign integer's to these variables, then all is good, they are written to the cell.
But, if I assign a text, then I receive only a 0 written into that cell.
I tried assigning alphanumeric values, and guess what, the output consists of only the numeric input I have had for the variable.
I tried formatting the output cell as Text, or Dim'ing the variables, with no success.
What am I doing wrong?
Thanks in advance,
Regards.
I am writing data into a cell with the following commands:
Code: Select all
Sheet = Doc.Sheets.getByName("Constants")
Cell = Sheet.getCellByPosition(3,0)
Cell.Value = Name
Sheet = Doc.Sheets.getByName("Constants")
Cell = Sheet.getCellByPosition(4,0)
Cell.Value = Number
But, if I assign a text, then I receive only a 0 written into that cell.
I tried assigning alphanumeric values, and guess what, the output consists of only the numeric input I have had for the variable.
I tried formatting the output cell as Text, or Dim'ing the variables, with no success.
What am I doing wrong?
Thanks in advance,
Regards.