google docsgoogle-apps-scriptgoogle-apps-script-add-ongoogle-sheets-addons
I've created a script or add on for my Google Document. The script exports the content to basic HTML.
When I create a new doc I can't find a way to import the scripts from the existing document. From the Google Document I have gone to Tools > Script editor. A blank script is created but I can't open or find any existing scripts.
Screenshot of my script and add-on:
When I create a new doc and go to the script editor I can't find any to open?
Goto File -> See Revision History. You should be able to change back to your old revisions from there.
You can add your script as a library in the new spreadsheet. Lets start from the beginning. This sample code will add a string to the active cell:
function libTest(text) {
var sh = SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet().getActiveCell();
sh.setValue(text);
}
Save the script, by creating a version:
Next, copy the Project Key from the script editor:
Publish the script as a web app (execute only you):
In the new spreadsheet, open the script editor. Chose Manage Libraries from the resources option and enter and select the key/library:
In the script editor you can now add the following code:
function test(){
libTest.libTest("jacobjan");
}
Best Answer
There are two basic categories of Apps Script files -
Bound files do not show up in your Google Drive. Stand Alone Apps Scripts files do show up in your Google Drive.
You can create multiple projects inside of an Apps Script file, but projects in other files can not be searched or loaded into the code editor. So, you can't do what you want to do.
If you want to share an Apps Script file to multiple documents, you have two options.
A Library runs slower, and is not totally secure if you want to protect your code. An Add-on has a one-time $5 dollar fee to be able to publish the Add-on. The best option, in my opinion, is to use an Add-on from a stand alone Apps Script file.