Macro Issue - Current Local Security - Allow System Access

Thu, 17 Jun 2010 07:18:49 GMT

Hi,

I have to automate Export to Excel for a Pivot table.

I can use obj.SendToExcel in macro but this create xl in Temp folder with name like CH01201006170934.xls.

I want xl to be stored in a particular folder with a specific name automatically.

For this I am using another macro with MyTable.CopyTableToClipboard

For this I am using CreateObject function for FileSystemObject and for Xl application .

For this object creation, I have to choose Allow System Access option from Current Local Security drop down.

Till now its fine. But everytime I open qv file, I ve to set this option before exporting pivot into xl.

Is there any method to get this option selected everytime or is there any other method to export pivot into excel where I can specify file name and path?

Pls suggest!!

Macro Issue - Current Local Security - Allow System Access

Thu, 17 Jun 2010 13:31:04 GMT

I got it.

Choose System Access for both - Requested Module Security and Local System Security

Now the selection will not go when we open qv file again.

Re: Macro Issue - Current Local Security - Allow System Access

chrisjbishop — Wed, 15 Jan 2014 09:20:12 GMT

This works great - many thanks.

topic Re: Macro Issue - Current Local Security - Allow System Access in QlikView

Macro Issue - Current Local Security - Allow System Access

Macro Issue - Current Local Security - Allow System Access

Re: Macro Issue - Current Local Security - Allow System Access