This project is a Data Access layer that can be used in any VBA application to connect to SQL Server. The purpose is to keep database connectivity tidy and core database commands centralized within a ...

Keywords: VBA, SQL, Bond Pricing, Excel, Financial Analysis, Access Database, Risk-Free Curve, LIBOR Rates, Duration Calculation, Bond Cash Flows, Data Management ...

I've been asked at work to create a small/simple database application for a week using Access 2003. So I need to learn basic MS Access and VBA to accomplish the task. I've currently ran into a little ...

I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very little ...