Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
This works great - many thanks.