Exporting to excel sheets

[umass]

Hey, here is another problem that you could probably help me with.

I have exported all the data to an excel sheet, but it is in a weird format. When I write to a .xls file, the data skips columns for some reason. Here is the line:

 

if (FileSize >= bytesToMB) and (FileSize < bytesToGB) then

totalSize = FileSize / bytesToMB

objOut.WriteLine ComputerName & " " & FileType & " " & counter _

& " " & objFolder.Path & " " & totalSize & " MB"

 

It skips columns after counter and after obj.Folder.Path. I played around with the number of spaces I have in between each parameter to see if it would change anything, but didn't work. Any suggestions?

[umass]

SOLVED: put commas in between quotes on the objOut.WriteLine line, and output to a .csv file, which can be opened by excel.