topic Macro Problem.....Creating folder using macro in QlikView

Macro Problem.....Creating folder using macro

Sun, 05 Jun 2011 18:19:31 GMT

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.

Macro Problem.....Creating folder using macro

Sun, 05 Jun 2011 18:25:42 GMT

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

Macro Problem.....Creating folder using macro

Mon, 06 Jun 2011 13:55:02 GMT

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

Macro Problem.....Creating folder using macro

Wed, 27 Jul 2011 15:23:07 GMT

Hope this helps!

Stefan"

Thanks - this did the trick for me