• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel App - VBA & SQL

Sathish KV

Active Member
Hi All,

This is a basic excel based application.

It uses an ADODB connection to connect to the Excel databases.

I have used SQL statements to query, insert and update records to the databases

There will be 3 files in the compressed folder.

One will be a macro file (Call Tracker.xlsm) and other two are the database

Just save all 3 files to the same folder and you can test the Call Tracker App

Remarks are given for each procedures in the Userform

I would try to give a detailed description once I find time