Macro Issue - Current Local Security - Allow System Access

[#1]

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!!

[#2]

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.

[chrisjbishop]

This works great - many thanks.