Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anybody help my with this little issue. I need to browse the 'Temporary Internet Files' folder, and get out information about filename and the time file is accessed. This may give me the possibility to make a Qlikview where it is possible to aim the internet-traffic and time consumtion.
Hi,
it also might be possible with a QlikView internal macro, but a quick solution is to use excel and the following vb-code to read the file informations of your folder, save the excel-sheet and then load it in QlikView:
Sub rad_file_information()
Const PATH = "C:\YOUR_FOLDER\"
With ThisWorkbook.Worksheets("Sheet1")
.[A1].Select
.[A3:F65000].ClearContents
.[A1:B1] = Array("Path:", PATH)
.[B2:F2] = Array("Name", "Date", "Time", "Size", "Folder")
..NumberFormat = "dd.mm.yyyy"
..NumberFormat = "hh:mm:ss"
..NumberFormat = "#,##0"
Call list_files(.[B3:F3], CreateObject( _
"Scripting.FileSystemObject").GetFolder(PATH))
..EntireColumn.AutoFit
End With
End Sub
Sub list_files(r As Range, folder As Variant)
Dim file As Varia...
Kind regards.
Thanks Pascal.
It works fine with all other folders except temporary internet files. It seems to be a special folder, handled speciel from the Internet explorer.
But still, thanks for your help.
regards
Allan