Free project plan & cost estimate in 48 hours.

Frequently asked questions

Can a VBA developer fix Excel macros that broke after moving to 64-bit Office?

Yes. First inspect Windows API Declare statements, pointer-sized variables, missing references, and any ActiveX or COM dependencies. Adding PtrSafe alone does not make every declaration correct; handles and pointers may require LongPtr. Testing should cover the affected Excel workflow on the actual Office architecture, including dependencies that may have no supported 64-bit equivalent.

Should we keep our Excel VBA application or rebuild it?

Keep VBA when the workflow is desktop-centered, the user group is manageable, and Excel remains the right interface. Consider a different architecture when concurrent editing, browser access, or centralized permissions dominate requirements. A review should separate useful calculation logic from workbook plumbing before recommending VBA cleanup, an Access redesign, or a move beyond Office.

Can VBA connect Excel or Access to SQL Server?

VBA can use ADO or DAO, depending on the application, to query databases and populate reports or forms. For SQL Server connections, review supported drivers, authentication, parameterized queries, and connection cleanup. Avoid embedding passwords in workbook code. Database operations should also handle timeouts and partial failures without leaving users unsure whether an update completed.

How do you make a shared VBA workbook easier to maintain?

A practical maintenance plan exports modules, class modules, and UserForms into source control, documents references, and separates calculation logic from worksheet events. Add explicit variable declarations, consistent error handling, and repeatable test workbooks. Distribution needs attention too: version labels, signed releases, and a clear update process help prevent multiple incompatible copies circulating.

How quickly can we interview a US-based VBA developer?

Most teams interview matched engineers within a week of the first call. Bring representative macros, your Office versions, database dependencies, and a description of the failures or backlog. Every engineer lives and works in the US. If the fit is not right, we bring in a replacement with a proper hand-over.

Are your developers really based in the US?

Yes. Every engineer lives and works in the United States. No offshore subcontracting and no hand-offs to another team. That's written into the contract.

How fast can someone start?

Most teams interview matched engineers within a week of the first call. Start dates depend on your interview process.