Macro problem

Thu, 06 Oct 2011 00:42:36 GMT

Hi,

I have a macro that moves particular files after reload, when I manually define the destination path it works fine but when I define the destination path based on the value of a variable it doesn't move the loaded files to the destination path..

Here's the code:

Function FuncMove(file)

SET dest = ActiveDocument.Variables("vDestination")

destination = dest.GetContent.String -> macro doesn't work if i use this

'dest = "D:\TAENA KA NOEL\Multi Sheet\LoadedWorkbooks\" -> when I use this the function works fine

SET filesys = CreateObject("Scripting.FileSystemObject")

If filesys.FileExists(file) Then

SET fsoFile = filesys.GetFile(file)

fsoFile.Move destination

End If

End Function

Macro problem

qliksus — Thu, 06 Oct 2011 05:52:33 GMT

Use something like

activedocument.variable("dest").setcontent vDestination.getcontent.string

instead of doing like

SET dest = ActiveDocument.Variables("vDestination")

destination = dest.GetContent.String

topic Macro problem in QlikView

Macro problem

Macro problem