Displaying strings of data in Excel
Posted on 2007-07-25
Hi, I need to save strings of data (numbers) in Excel using Visual Basic. This is what the data looks like:
First Set of data Saved: (First Row)
10.24 100.4 230.45 301.45 75.2 20.56 39.47
Second Set of data Saved: (Second Row)
About the same as first set.
Third Set of data Saved (Third Row)
About the same as first.
The data is being saved on a excel file using:
LogFile = FreeFile
Open "C:\Log\AllData.xls" For Append As #LogFile
Print #LogFile, Message
The issue I have is that the data does not get organized into columns and rows, per every set of data saved. Can anyone please tell me how to organized the data sent into columns and rows? The strings of data will always be the same length. About 8 pieces of data per string. Which means eight columns and one row per string.