forked from rfredman/TestGitQlikview
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathReloadQVWFiles.vbs
More file actions
39 lines (32 loc) · 874 Bytes
/
Copy pathReloadQVWFiles.vbs
File metadata and controls
39 lines (32 loc) · 874 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Dim fso, Qv
' create a global copy of the filesystem object
Set fso = CreateObject("Scripting.FileSystemObject")
Set Qv = CreateObject("QlikTech.QlikView")
RecurseFolders ".","1.Extract"
'RecurseFolders ".,2.Transform"
'RecurseFolders ".,3.Load"
Set fso = Nothing
Qv.Quit
Set Qv = Nothing
Sub RecurseFolders(sPath,Target)
With fso.GetFolder(sPath)
if .SubFolders.Count > 0 Then
For Each Folder In .SubFolders
if Left(Folder.Name, 1) <> "." Then
if Folder.name=Target Then
for each File in Folder.Files
OpenClose(File)
Next
end if
RecurseFolders folder.Path, Target
End If
Next
End if
End With
End Sub
Function OpenClose(qvwFullPath)
Set docObj = Qv.OpenDocEx (qvwFullPath,0,false) ' Open the document
docObj.Reload
docObj.Save
docObj.CloseDoc
End Function