Supermetrics Support Forum

How can I use the functions in an existing workbook I have?

If instead of using the provided template file you want build on an existing workbook of yours, you need to follow these steps to embed the functions into the workbook:


EXCEL

  1. Open the VBA macro editor (to find the VBA editor in Excel 2007, check Options: Popular: Show Developer tab in the Ribbon. In Excel 2003, you can open the ditor from Tools: Macro: Visual Basic Editor)
  2. In the editor, select Insert: Module 
  3. Copy all the VBA code from the template file into your new module
  4. The functions can now be used in the workbook. If they don't work, check that your Excel security settings allow the execution of macros. If they don't, change the setting and restrart Excel.


GOOGLE SHEETS

  1. In Google Sheets, in your existing spreadsheet, open the menu bar and go to Tools: Script Editor: Blank project
  2. Copy all the script code in the template into the Script Editor of the uploaded spreadsheet
  3. In the Script Editor, press Save and return to the spreadsheet


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.