Continuing the concept of collaboration that was discussed in a previous article (Sharing data/Collaboration), this article will focus on sharing your programs that run a series of steps to manipulate the data.
In Excel, you have two ways to build a program that can run a series of steps; Macros and Visual Basic. Regardless of which you are using, they are both typically embedded in the spreadsheet so sharing it is just as easy as sharing the data; just email it. Unfortunately, it becomes very complex from this point forward. Since the intent of this article is collaboration, it is assumed that you are going to allow the other person (or multiple people) to edit your scripts. At this point you have now lost control of it. Each person can make as many changes as they choose and there is no requirement to inform you about the updates. You are probably hoping that the other people know how to program as well as you do or you will most likely become tech support for them.
In Paxata, the collection of rules that you build are referred to as a project. A project is built with point and click, there is no programming language to learn. To share a project in Paxata is as simple as a click of the mouse. It is important to note that when you share in Paxata, you are not making another copy of the project. Instead, all the users that you give the rights to work on your project will use the same copy. This will eliminate a lot of problems because everyone will work from the same, consistent view.
To share a project