recurring program , can i make a function ?

[Broly21000]

Hello evryone ,

I have a sheet that makes a program that I use often, is it possible to make it a function with parameters in which I could call in all applications?
For example a function that allows me to do a load to generate all the orders of a customer for a specific category.

can I make a getOrder function with customer id and category id as parameters

and that I can call this function everywhere ?

[Aurelien_Martinez · Accepted solution]

Hi,

You can create function with the key word sub. Example :

Sub getOrder(customer_id, category_id)

//script

end sub

Call getOrder('1323', 'AAE33');

[Broly21000]

thank you for your comment, how to call this function from another application without rewriting it?

[Aurelien_Martinez]

You can write your function in text file and load it with the include
instruction.