Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what does pk ??? mean ???

Status
Not open for further replies.

masterofc

Programmer
Sep 8, 2015
8
NL
when I run the code below I get the result pk??? but what does it mean ? it should echo all the value's in the xlsx

Option Explicit 'Force explicit variable declaration

'decales variable
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
Dim strPath, RootFolder, objFolder, colFiles
Dim objFSO, strTextFile, strData, strLine, arrLines, objFile, strFolder, tokens, ArgumentOne
CONST ForReading=1

RootFolder = "E:\"
strTextFile = "C:\Users\Casper\Pictures\voorJohan\1978.xlsx"
Set objFSO = CreateObject("Scripting.FileSystemObject")
strData = objFSO.OpenTextFile(strTextFile,ForReading).ReadAll
arrLines = Split(strData,vbCrLf)

For Each strLine in arrLines
'Declare & print arguments
ArgumentOne= strLine
WScript.Echo (argumentOne)
Next
 
hi,

Try opening this workbook with Notepad or some other text editor, and observe the results for your edification.

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top