Why all the comma's

March 28, 2010 at 07:46:12
Specs: Windows 7
I have written a vbscript which uses excel to perform some calculations on the data. I found the following line to open my text file in excel.
objWorkbook = objExcel.Workbooks.OpenText("C:\Users\Brian\Desktop\Excel_Team.txt",,,xlDelimited,,,,,,,True,",")
It works fine, but why are there so many comma's in the line. What do they mean?

Any help with this would be appreciated.


See More: Why all the commas

Report •


#1
March 28, 2010 at 08:29:11
Commas are just separator and all empty positional parameters are ... empty, making the commas be next to each other ?

Report •

#2
March 28, 2010 at 10:03:50
Pretty much, yeah. The script is opening the file, while using a lot of Excel's defaults. The function's prototype looks like this: OpenText(FileName, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, TextVisualLayout, DecimalSeparator, ThousandsSeparator, TrailingMinusNumbers, Local)

Report •

#3
March 28, 2010 at 10:38:01
Get the idea, thanks for the replies.

Report •
Related Solutions


Ask Question