Exporting to excel sheets
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?