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

QlikView OCX Error "Can not open file txt for write"

Hi Dear QV Community

I Have a problem with a Macro execution from IE Pluggin Client, this is the macro

-----

sub Export

  set obj= ActiveDocument.getSheetObject("CH171")

  FileName = ActiveDocument.Variables("vRutaArchivo").GetContent.String

  obj.Export FileName, ","

End Sub

------

In QV Desktop works fine, i assigned Full Control to folder for Accout Services QlikView  and QlikView Administrator Group but not work.

The error message is "Can not open the file D:\Folder\test.txt for write"

The following options were already established

1) D:\folder\ is valid and there is a folder on the server and is registered as a folder in QVMC -> System -> Setup -> QlikView Servers -> QVS@ -> Folders->Mounted Folders

2) The Windows User to run QV Services has full control over D:\folder\

3) The Windows Users Group called "QlikView Administrators" has full control over D:\folder\

4) On QVMC -> System -> Setup -> QlikView Servers -> QVS@ -> Security -> Miscellaneous are cheked the boxes "Allow unsafe macros" and "Allow macro execution on server"

4 Replies
Not applicable
Author

When remotely accessing a server document with the IE plugin, macro are executed on the server-side, so you have to check that d:\folder\ is a valid path on the server and that the user executing the qlikviewserver service has rights to write to it. You may also have to change the security settings to allow unsafe macro on the server (not sure about this one).

Not applicable
Author

HI jgeorge

The following options were already established

1) D:\folder\ is valid and there is a folder on the server and is registered as a folder in QVMC -> System -> Setup -> QlikView Servers -> QVS@ -> Folders->Mounted Folders

2) The Windows User to run QV Services has full control over D:\folder\

3) The Windows Users Group called "QlikView Administrators" has full control over D:\folder\

4) On QVMC -> System -> Setup -> QlikView Servers -> QVS@ -> Security -> Miscellaneous are cheked the boxes "Allow unsafe macros" and "Allow macro execution on server"

Not applicable
Author

Hi,

I'm facing the same problem and tried in the community to see if someone already answered your issue and didn't see any one answered. But, if you have solutions or some other alternative that worked for you please do post it here. Thank you,

Regards,

Ram

jerrysvensson
Partner - Specialist II
Partner - Specialist II

If you run a macro using Plugin client it will run locally, if you use Ajax as client it will run server side.

Try creating D:\Folder on the client machine and try again.