This is the first post of Vikram Shankar Mathur on this brand new website. Cheers !! I accord you a very warm welcome and also invite you to freely comment on whatever you wish here, we are always open for improvements and innovations. Thanks and welcome again.
To know more about me, you can head over to my Personal Website or my Professional Blog. Cheers !!
CA VIKRAM SHANKAR MATHUR
INTRODUCTION TO VBA / VB6
Hello, folks!! You guys must be aware that I am slowly and steadily gaining popularity as the “EXCEL TRAINER AHMEDABAD” and the reason is that I have spent 30 long years into pottering with the various objects that Microsoft Excel has to offer in the form of the SpreadSheet / WorkSheet / Workbook Objects as a part of the Visual Basic for Applications (VBA) programming back-end to MSExcel, MSWord and MSAccess. Now you will tell me that even MSPowerpoint supports VBA, and I will correct you by saying that the important word here is “SUPPORTS“. You see, VBA will not work on a software that does not support the VBE (Visual Basic Editor) environment!! So MSPublisher and MSPowerpoint have been given the facility of being “programmable” through the other three more popular applications in the Office365 Suite (Business or Retail). Hence, we can conclude the above argument that while Excel, Word and Access provide a VBE environment where the methods and properties of the “Sheet / Document / Database” objects respectively are exposed, Powerpoint and Publisher are controllable from the former three softwares. Surprised? I should think so!!
One important distinction is to be made when thinking about whether to use VBA or VB6 (Visual basic 6.0), is that while you can create an EXE / DLL / VBE-Addin using the latter, you can only program the Microsoft Form 2.0 ActiveX objects available in the VBA Projects, namely, Modules, Class Modules and Userforms containing the ActiveX Controls that are available, namely TextBox, Label, ComboBox, ListBox, MultiPage, RefEdit, ScrollBar etc. The similarity between VBA and VB6 is only restricted to the fact that Visual Basic terminology remains same within the two, the important difference being that while VB6 gives you the ability to create stand-alone products, VBA only allows manipulation of, say, Worksheets in Excel, Documents in Work and Database in Access.
This discussion, however is restricted to the Topic, namely “Use of Excel and VBA/VB6 in Devlopment of MIS. The slides below will speak for themselves. They were created for a Lecture Meeting held at CA Nitin M. Pathak’s Office at B-1111, Mondeal Heights, S. G. Highway, Ahmedabad-380015 on 29th November, 2019 at approx 6:30 pm onwards. Please go through these slides and if you have any questions about them, I shall be more than delighted to answer them. Cheers !!
CA VIKRAM SHANKAR MATHUR
01-Dec-2019 | 01:00 Hours IST
Use of Excel and VBA/VB6 in Devlopment of MIS
VSMathurCoIn Video Blog 