Q&A: CAN SOMEONE HELP ME FIGURE OUT A COLOR IN HTML?

Several ways to do that, depending on the format of the text document… has to be plain text, not formatted.

Open notepad, and type:

dim fso, fl, flContents, flLine
dim xl, xlWB, xlSheet, xlRange
dim x, y
set xl = new Excel.Application
set xlWb = xl.Workbooks.open ( “excel.xls” )
set slSheet = xlWB.sheets ( “The Sheet” )
set xlRange = xlSheet.Range ( “A2″ )

Set fso = CreateObject( “Scripting.FileSystemObject” )
Set fl = fso.OpenTextFile ( “yourfile.txt”, 1 )
flContents = split( fl.ReadAll, vbCrLf )
‘ Splits up file in separate lines
fl.Close
Set fl = Nothing

for x = lbound(flContents) to uBound(flContents)
 flLine = split( flContents(x), vbTab )
 ’ splits each line in tab separated parts
 for y = lbound(flLine) to ubound(flLine)
  xlRange.offset(x, y) = flLine(y)
next

xlWB.Save
xlWB.Close False ‘ False is to prevent second save action
set xlWB = Nothing

set fso = Nothing

Save file as a .VBS file, and doubleclick to run.

That should sorta help you on your way, I hope.