Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

3 Replies
Not applicable
Author

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
Author

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
Author

"

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