Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

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

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

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

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

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

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

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
Valued Contributor II

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

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.

Community Browser