User can't export to QVD with macro

[#1]

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?

[marcus_sommer]

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

[#3]

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

[marcus_sommer · Accepted solution]

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.

[#5]

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!