Hi i tried to use this Script for Importrange from my Target workbook. but i could not found that where i did mistake for this advise Page Ref:
My Setup as below;
function ImportDataRange() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var ssraw = SpreadsheetApp.openById("0AhioeCK_-aU4dHlLWjlDd0J5LVNyNHVVSEdQQnFsNEE");
var sheetraw = ssraw.getSheetByName("Sheet1");
var range = sheetraw.getRange("A2");
var data = range.getValues(); sheet.getRange("AZ2000").setValues(data)
}
and the Result as : error: You do not have permission to call setValues (line 15)
some please advise on it.
Thanks!
|