Visual Basic for Applications

Bespoke software for all platforms

Bespoke Software Development - Visual Basic for Applications

The StyleTech development team have been creating bespoke software developments using Visual Basic for Applications (VBA) since 1998.

Microsoft Visual Basic for Applications is closely related to Visual Basic and both languages use the same Visual Basic Runtime library. The main difference between VBA and VB is that VBA code can only run from within a host application (e.g. Excel), rather than as a standalone program. VBA can be used to control one application from another by using OLE Automation. For example, VBA can automatically create a Word document using data from within an Excel worksheet. VBA can use ActiveX controls but you cannot develop an ActiveX control using VBA (only VB).

Today, many applications and integrations that were written with VBA still exist and operate. StyleTech can assist with the continued maintenance and development of these systems by:

  • Understanding the VBA codebase
  • Implementing any necessary bug fixes
  • Introducing modern security practices
  • Improving the responsiveness of the system
  • Upgrading the database engine
  • Implementing screen design improvements
  • Providing on-going system support
  • Providing on-going system development
  • Producing and implementing a disaster / recovery plan

How we do it

we listen to your
business needs
we talk english,
no confusing jargon
we deliver
on-time, on-budget

in business for over 18 years

StyleTech has been delivering an award-winning service since 1999.

Yorkshire based team

We are based in Yorkshire and proud to complete all projects in-house (we never outsource).

Over 500 bespoke projects completed

We have obtained a vast range of industry and business knowledge within the team.

We talk English

We talk in your language, no technical jargon (unless you want it).

Award Winning Developments
IT'S ALL ABOUT YOUR DATA

Our Expertise...

Azure Services

  • web apps
  • web jobs
  • logic apps
  • machine learning
  • mobile services
  • search
  • queues
  • service bus
  • event streaming
  • blob storage
  • batch

Methodologies

  • agile / scrum
  • prince2
  • plan driven
  • test driven
  • prototype

Platforms

  • windows
  • mac
  • linux

NHS

  • SystmOne
  • IPM
  • Lorenzo
  • RiO
  • MHCT
  • HoNOS
  • PbR

Council

  • AchieveForms
  • OPENHousing
  • OneServe
  • Uniform
  • PowerSuite

Our News & Blog Posts

  • Thank you Xamarin and Microsoft for the invite, we are really excited about this opportunity
  • Congratulations to the StyleTech development team for gaining Telerik Kendo UI certification, very impressive!

Our valued partners