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
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