Discussion board where members can get started with QlikView.
I am using Qliksense and I would like to record the information of all xls/xlsx files in folder. But I am getting the error over and over again.
Any idea of this error? Here is the script as well.
Change the line
For Each tblFile in FileList(Root & '\*.' & FileExtension)
Let Root='\\lnn63f1\u_t1487402003\sasidp\My Documents';
For Each FileExtension in 'xls','xslx'
For Each tblFile in FileList(Root & '\*.$(FileExtension)')
'$(tblFile)' AS FileName,
FileSize('$(tblFile)') As FileSize,
FileTime('$(tblFile)') As FileTime
View solution in original post
Is there any variable called Ext in your Sub Routine ??
Have you got this working?
It works! Thanks Sasidhar.