Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers
I have yet another question. Using the application posted on here -> Re: How to browse a folder and get file using external macro in qlikview? I have gotten to a point where I can let the user browse for a file and then do a partial reload to load additional data. I only have two issues:
Any help on this would be greatly appreciated
Best,
Sunny
If anybody is curious, I was able to resolve the first issue where the edit module was showing up by changing the script for the macro slightly.
Sub BrowseFolder
Const OverWrite = True
Dim destpath, srcFiles
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.BrowseForFolder(0, "Example", 16384,"Computer")
On Error Resume Next
If objFolder Is Nothing Then
Wscript.Quit
End If
ActiveDocument.Variables("vFileName").SetContent objFolder.title, true
ActiveDocument.Variables("vFolderName").SetContent objFolder.self.path, true
MsgBox " Path: " & objFolder.self.path
End Sub
Still need help with the first issue.
Best,
Sunny