I'm having some trouble with a VBA module in Excel. I have a script that references cells in my spreadsheet and writes the values in comma separated lines to a text file.
The way I do it boils down to:
Dim line_data(0 to 1) As String line_data(0) = SheetNameVar.Cells(7, "C").Value line_data(1) = SheetNameVar.Cells(8, "C").Value Dim line As String line = Join(line_data, ",") TextStreamNameVar.WriteLine line
Everything works as expected, but I keep getting values written to my text file in scientific notation if they have zeroes after the decimal. For example,
I have the sheet displayed as decimals with six digits after the decimal, but that doesn't seem to affect the sheet writing.
I can't seem to find any information talking about Excel VBA converting the value notation when writing to a text stream. Is there a way to prevent this? Ideally it wouldn't rely on the sheet formatting so I can display less precision there for readability. But I need the values to appear like this in my text file:
Thanks in advance for any help!