Microsoft Application and Software Development
Looking for help with an Excel project? Need help building
an Access database or fixing an existing one? Wouldn't you like
to automate some of those tedious and repetitive tasks at work? Or maybe you even
have an idea for a commercial Excel add-in. Call or
email us today for a free consultation.
What is VBA?
With VBA (Visual Basic for Applications) you can query and retrieve
data from an Access database, analyze and graph it in Excel, and
send it in an email from Outlook -- all with a single click. VBA is the programming language behind the Microsoft Office suite.Using VBA we can automate repetitive, complex, tedious tasks, giving
you and your staff more time to do the work at hand. Most
projects pay for themselves within a few months.
Many of our solutions utilize both Excel and Access. Business applications
typically require a database such as SQL Server or Access. The data can then be retrieved for analysis and reporting using
Excel. By separating the data and the front-end (Excel), we
can emulate a "client-server" solution -- which means usability,
flexibility, and scalability.
Excel VBA Programming & Application Development
Whether you want to automate a weekly report, create a few custom
worksheet functions, or build a state-of-the-art commercial Excel
add-in, we can help. We have strong financial and analytical
skills, and extensive programming experience. Excel VBA programming
and application development is what we do best.
Access VBA Programming & Application Development
Many projects require a database to store mission-critical information,
and Microsoft Access is the most popular desktop database on the
market. We've developed Access and SQL Server database solutions
for companies and government organizations across the country. We can also help with an existing database.
These applications are usually more sophisticated programs that
harness the power of the Microsoft Windows and .NET framework. A .NET application is a stand-alone program that offers the look,
feel, and performance of an out-of-the-box Windows or web application. Please
email us for more details.
Whether you need help with a VBA-based add-in, or a commercial grade
add-in built with the latest .NET technology and C++, we can help. Both of our commercial add-ins -- SolutionTree and TruSens -- were
created by Steve Stricklen, and he does all the add-in development
email us for more details.
C/C++ Excel Custom Function Writing
Custom worksheet functions can be written in VBA, but for more calculation
intensive operations, such as simulation and sensitivity analysis,
VBA functions can be slow. To get optimal performance, you'll
need to rewrite them in C or C++, just like Excel's built-in functions. If you have a VBA function that you want to upgrade to C/C++, let
us know. Or, if you have just a vague notion of what you're
looking to do, we can assist. We'll work with you
to create just the right function. Please
email us for more information.
email us now to get started on a custom solution for your company.