Create folder with macro

souadouert — Thu, 22 Feb 2018 09:47:55 GMT

I used this macro to create folder and i give the system access , But the folder didnt create and i have not any error

SUB folder()

set Var = ActiveDocument.GetVariable("D:\TEST")

dim filesys, newfolder, newfolderpath

newfolderpath = Var.GetContent.String

set filesys=CreateObject("Scripting.FileSystemObject")

If Not filesys.FolderExists(newfolderpath) Then

Set newfolder = filesys.CreateFolder(newfolderpath)

msgbox("A new folder has been created at: " & newfolderpath)

End If

END SUB

Re: Create folder with macro

marcus_sommer — Thu, 22 Feb 2018 12:58:29 GMT

Are you sure that you have variable with the name of "D:\TEST" and that they contained a valid path? I assume that this is rather your aimed target-path and not a variable. Therefore go into the gui and create there a variable maybe "FolderPath" and assign "D:\TEST" as value and it should work with:

...

set Var = ActiveDocument.GetVariable("FolderPath")

...

- Marcus

topic Create folder with macro in QlikView

Create folder with macro

Re: Create folder with macro