Search This Blog

Monday, 2 September 2019

[02.09.2019]-First Post


Software

VISUAL BASIC FOR APPLICATIONS
We have been doing programming in the Visual Basic Editor (VBE) provided by default in all versions of Microsoft Office since Office’2000, especially in Microsoft (MS) Excel and Access. The details of this expertise are too technical to be mentioned on this page alone, but essentially we use Class Modules, Code Modules and Userforms in the Visual Basic for Applications (VBA) environment to suit the purpose of the final program.
EXCEL SPREADSHEET – ADVANCED FORMULAE
For instance, we have created a Cashbook program that only handles the Cheque Payment Voucher in one separate worksheet and it’s listing on another worksheet. Another instance of the pure programming using advanced formulae is the Cheque Mapping Software developed by us 10 years ago for handling the outsourcing of Cheques received for the Loans Department of a high-profile International Bank operating all over India, but for the city of Ahmedabad only.



What is VBA-Excel About?

We have been programming the Visual Basic for Applications as the back-end of Microsoft Office 2000 / 2007 and 2013) as well as the versions before that also since the year 2000, so we have been effectively  programming in this environment for more than 15 years now. Basically, in all these years, there was no commercial exploitation being done of these capabilities, which essentially began as an extension of the Macro-Programming available in Lotus 1-2-3. However, as on date, there is a lot more being done in this area by us than just macros! We are basically OOP (Object Oriented Programmers) and our biggest strength is that we are a Chartered Accountancy firm who provides these services mainly to our own clients.

Contact Us

We can be contacted at the address given at the foot of this page, where an office exists for the rest of the times other than those specified below:

OFFICE ADDRESS:
A-107, Doctor House,
Above Parimal Railway Underpass,
Off Chimanlal Girdharlal Road, Ellisbrige,
AHMEDABAD-380006, Gujarat, INDIA
Cell: +91-9998090111 / +91-8460890111
Email: vsmathurco@gmail.com | vsmathur@vsmathur.co.in

Phone: +91-79-26462131
Email: vsmathur@vsmathur.co.in
Web: http://vbacoder1962.wordpress.com/vba-excel.htm


No comments:

Post a comment