Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Macro Problem.....Creating folder using macro

Hi All,

Please help out.....thanks in advance......

I use the following macro I use......

sub test

dim fsoObj

set fsoObj = CreateObject("Scripting.FileSystemObject")

set obj = ActiveDocument.GetSheetObject("CH01")

fsoObj.CreateFolder("C:\Images")

obj.ExportBitmapToFile "C:\Images\test.bmp"

end sub

and I get the following error msg.....

ActiveX component can't create object: 'Scripting.FileSystemObject'

pls help me out.....

All I need is to create a folder in the c drive with the name Images.

1 Solution

Accepted Solutions
Not applicable

Macro Problem.....Creating folder using macro

Hi Prasanna,

It's because of the security issue only means the system is not accepting the request of creating a folder.

so you have to give the system access first which stefan mentioned above.

Kindly,

Vinoth

3 Replies
Not applicable

Macro Problem.....Creating folder using macro

Hi,

when you are in the macro module screen at the bottom left in "Request module security" choose "System access" and in "Current local security" choose "Allow system access". This will allow QV to access the file system

Hope this helps!

Stefan

Not applicable

Macro Problem.....Creating folder using macro

Hi Prasanna,

It's because of the security issue only means the system is not accepting the request of creating a folder.

so you have to give the system access first which stefan mentioned above.

Kindly,

Vinoth

Not applicable

Macro Problem.....Creating folder using macro

"

when you are in the macro module screen at the bottom left in "Request module security" choose "System access" and in "Current local security" choose "Allow system access". This will allow QV to access the file system

Hope this helps!

Stefan"

Thanks - this did the trick for me

Community Browser