topic Re: User can't export to QVD with macro in QlikView

User can't export to QVD with macro

Mon, 06 May 2013 13:45:50 GMT

Hi!

I've created a simple macro which gives the user a possibility to export a table to a QVD using a macro. It looks like this:

sub ExportObject()
set v=ActiveDocument.getVariable("vChosenWeek")
set u=ActiveDocument.getVariable("vChosenYear")
path="E:\QlikView\SourceDocuments\QVD\History\"
Filename="Week "&v.getContent.string & " " &u.getContent.string & ".qvd"
call test("CH173",path&Filename)
end Sub
sub test(objectID,FilePath)
set v=ActiveDocument.getVariable("vChosenWeek")
set u=ActiveDocument.getVariable("vChosenYear")
set o = ActiveDocument.GetSheetObject(objectID)
o.Exportbiff FilePath
set o=nothing
msgbox("Week"&v.getContent.string &" år " &u.getContent.string &" exportet." )
end sub

This works for my administrator-user. But it doesnt work for other users, allthough I did give them access to the folder where the QVD is created.

Any suggestions on how to solve this?

Re: User can't export to QVD with macro

jonathan_dau — Mon, 06 May 2013 14:27:10 GMT

Hi,

Did you try to check 'Macro Override Security' in Properties --> Security -->

Hope that helps

Regards

Jonathan

Re: User can't export to QVD with macro

Tue, 07 May 2013 06:47:06 GMT

Hi!

I already checked that box, doesn't help I'm afraid.

Any other suggestions?

Re: User can't export to QVD with macro

Sokkorn — Tue, 07 May 2013 06:50:52 GMT

Hi,

Make sure you use System Access

Regards,

Sokkorn

Re: User can't export to QVD with macro

Wed, 15 May 2013 11:40:04 GMT

Sorry for the late reply. I tried that, didn't help I'm afraid.

Re: User can't export to QVD with macro

marcus_sommer — Wed, 15 May 2013 13:35:16 GMT

Check the settings in user- and document-properties in tab security and the settings.ini from the users:

C:\Users\USER\AppData\Roaming\QlikTech\QlikView\settings.ini (macro execution could be forbidden)

- Marcus

Re: User can't export to QVD with macro

Anonymous — Wed, 15 May 2013 13:38:46 GMT

Try this from API Guide:

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4 '4 = qvd

Re: User can't export to QVD with macro

Fri, 17 May 2013 07:11:34 GMT

Didn't work either I'm afraid 😕

Re: User can't export to QVD with macro

marcus_sommer — Fri, 17 May 2013 07:20:10 GMT

Work other simple macros like msgbox? Receives the user a security message about macro execution?

Re: User can't export to QVD with macro

Fri, 17 May 2013 07:37:45 GMT

Yes the user gets the msgbox so I guess the macro is being executed, but the file isn't created for some reason.

Re: User can't export to QVD with macro

marcus_sommer — Fri, 17 May 2013 07:55:31 GMT

Access to external files requires extra rights - have you checked all settings (see post above)?

Re: User can't export to QVD with macro

Fri, 17 May 2013 08:37:29 GMT

I tried to look into that file, could't find anything on forbidden macros though. Do you know what this variable is called?

Re: User can't export to QVD with macro

marcus_sommer — Fri, 17 May 2013 09:29:43 GMT

I have also none entries about security in settings.ini. I think those entries will only set if anything became forbidden. For test you could remove this file (after backup) - the settings.ini will new create. I think other settings/access rights are wrong, possibly the path is wrong for the user and E: is here another source.

Re: User can't export to QVD with macro

Fri, 17 May 2013 12:54:02 GMT

You were right! It was actually that simple that the user did have another path to E: on the network. Should have thought of that. Thanks!