VBA Macro Development
We provide VBA development services for Microsoft Project, Excel, Access, Word and PowerPoint. We can also write add-ins for these applications and help build and share data with SQL Server databases.
VBA for any of the Office applications can control everything in all other applications: seamlessly. So if you need the power of Project and Excel combined, or Excel and Word then we can develop a solution for you.
To discuss how Rod Gill can help you with your VBA development, please email Rod by clicking here.
Our development costs are surprisingly low since VBA is a very productive development tool and we know the best way to develop solutions without having to experiment. We can give fixed price contracts, but to do so we need manually created samples of files before and after running the code so we know exactly what information you want manipulated and how it should look.
If you can't specify exactly what you need, we can work on a timesheet basis until the code is specified, then provide a fixed price for the rest.
Finally if what's needed isn't clear and requirements and code needs to evolve, we can provide a minimum and maximum price for time needed and if we exceed the maximum cost extra time is half price (just so we both have skin in the game and work to complete the project).
Rod's main web site is here.
Microsoft's Project for Windows is the most widely used project scheduling software available in the world today. Rod Gill wrote the only book on Project VBA in the World and was asked to speak at the Microsoft Project conference in Phoenix 2009 on advanced uses for Project VBA.
Project is a great tool for managing the information for your projects. Data management and reporting is what makes Project VBA so useful and productive.
If there is anything Project can't quite do that you need, it is very likely that a little Project VBA will meet your needs. You will be pleasantly surprised at how much can be achieved in just a few days.
Excel is the world's best reporting and analysis tool. Use Excel VBA for creating reports on projects either directly from Microsoft Project or from databases or other Excel workbooks.
Access is a very fast development tool. Whether you use .mdb files for storing the data or SQL Server, Access allows quick development of solutions for your business. If you have need for an application with a lot of data to store and manipulate give us a call.
Microsoft Word is a very powerful word processor. With Word VBA it's easy to import or export data to or from other applications or databases. So if you need your reports automated, call us.
If you need a more robust solution that needs to be rolled out to a lot of users, then we can convert VBA to VB add-ins.
It's more of a question of "What do we want to do?: rather than
"What can we do?"