Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

VBscript Help: Moving a file - referencing a variable location

Hi All,

I have a VBscript that copies a file & places it in a different location.  The code works when the location of the file is hardcoded, but I need to be based on a variable which is defined by a different macro.

The part I need help with is:

Current code & working

SoureFile = "c:\sourcefolder\anyfile.txt"

but I have a variable varFileOpen which =  "c:\sourcefolder\anyfile.txt"..... but varFileOpen is defined by a macro.

Can anyone help with the changes I need to make? Thanks

Community Browser