SpreadsheetApp.openByName

204 views

Skip to first unread message

Mohamed Salah

unread,

Oct 7, 2023, 4:59:26 AM10/7/23

to Google Apps Script Community

Hi,

I am getting an error using this function in Google Apps Script

"TypeError: SpreadsheetApp.openByName is not a function (line 13, file "Code")"

The same code was working couple of minutes ago. But suddenly it is not working in my project. Please help

Brett Grear

unread,

Oct 7, 2023, 7:05:06 AM10/7/23

to Google Apps Script Community

There is no such function. It would cause chaos if you had more than one file with the same name. Please share your code. Usually the function should be openById() because IDs are unique.

Reply all

Reply to author

Forward

0 new messages