ActiveX WITH ONE EXAMPLE

The problem is that the casual user does not typically understand what an ActiveX control is, or what the consequences of allowing an ActiveX control to run might be. First of all, an ActiveX is a set of object-oriented programming (OOP) technologies and tools. Programmers writing for ActiveX create components, self-sufficient programs that can be run by the Windows operating system. The components, which are known as ActiveX controls, are roughly equivalent to Java applets.

One of the main advantages of ActiveX components is that they can be re-used by many applications.

Look at the following example of a component, a DLL file.

In India, and in most of its States, the retirement age for the government servant is 60 years. The person, after he or she completes his 60 years, retires on the last day of the month in which his or her date of birth falls.

It has one stipulation. If the date of birth falls on first of the month, he or she will retire on the last day of the preceding month.

This will be clear from the following example:
Date of Birth                                    Date of Retirement
15-04-1950                                        30-04-2010
01-03-1950                                        28-02-2010
01-03-1948                                        29-02-2008
01-01-1952                                        31-12-2011
15-02-1950                                        28-02-2010
15-02-1948                                        29-02-2008
I have created one 'component' i.e. one DLL file to solve this problem of calculation which can be used in any MS Excel file or MS Access file through a very small piece of code in VBA, or can be embedded in any other Visual Basic or some other programming platform. 
Take it from me at sanjaymohanb@yahoo.com
Open MS Excel. Save it as 'Book1'. Press Alt + F11. Following screen appears:

Right click 'VBAPROJECT (Book1).  Select Insert à  Module. A module in the name of 'Module1' opens.  Click Tools (on Menu bar) à References. Following window appears.

Click Browse. Find your DLL file. Select by pressing 'Open' command button. The file will be available in the window as shown above. Select it by clicking its check box. Press 'OK'. The VBA has accepted your DLL file and set a reference to it.
We shall write a little code, but before this, please remember (From VB 6 Help):

–        After you set a reference to an object library (i.e. DLL file in this case) by selecting the check box next to its name, you can find a specific object and its methods and properties in the Object Browser.

–        If you are not using any objects in a referenced library, you should clear the check box for that reference to minimize the number of object references Visual Basic must resolve, thus reducing the time it takes your project to compile. You can't remove a reference for an item that is used in your project.

–        If you remove a reference to an object that your are currently using in your project, you will receive an error the next time you refer to that object.

–        References not in use are listed alphabetically.

–        You can't remove the "Visual Basic For Applications" and "Visual Basic objects and procedures" references, because they are necessary for running Visual Basic. 
Write down following code in module. Please remember at various places the intelli-sense as build in VBA will work, and drop down menus will open automatically.

Public Function fDtRetirement(DoB As Date) As Date
'Dob stands for Date of Birth
Static A As dlPrjDOR.clsDOR
Set A = New dlPrjDOR.clsDOR
fDtRetirement = A.CalDOR(DoB)
End Function

Close the Microsoft Visual Basic window. Go to MS Excel sheet; use this 'User Defined' function. The windows given below are self-explanatory.

India needs its electronic product industry.

The demand for electronic products is increasing with an enormous acceleration. India does not have a, 'industry type' electronic product industry.

According to a recent report by Ernst & Young, the Indian domestic demand for electronics products is expected to reach $125 billion by 2014, up from the current level of $45 billion annually. The primary demand drivers are sectors like telecom, defence, IT and e-governance, automotive, consumer electronics, and energy.

This may result in sidelining petroleum products in so far as the foreign trade deficit is concerned. On the other hand, if this unique opportunity is utilized, it can create a large industry catering to domestic consumption, which will help achieve self reliance in strategic sectors like telecom and defence, while leading to large exports.

Electronic products contribute to over 22 percent of GDP of Israel and over 15 percent for Korea and Taiwan. Also, as a global player, U.S. has over 40 percent share of global electronic products markets and China has 15 percent, whereas the share of India is close to nil.

Given these ingredients of huge domestic demand coupled with availability of highly talented technical and managerial workforce, not to talk of venture capitalists that have the financial resources to provide the necessary funding for capable product startups, what is missing and why don’t we have the likes of Cisco, Apple, Nokia, etc. etc. from India? 

CORE BANKING – JUST NOT SUFFICIENT

Central Bank of India–one of the largest public sector banks in India—plans to make huge Information Technology (IT) investments to the tune of Rs 500 crores. As part of this IT investment, the bank plans to computerize more than 2000 branches using a core banking system (CBS) by end 2010. Currently, the Bank has 3600 branches across India, out of which only 1400 branches have been covered under CBS. The Bank wishes to connect all their branches using CBS. The technology partner is TCS.


Important to note, the Bank has seven regional rural banks (RRBs). As per Reserve Bank of India's guideline, implementing CBS is the sponsoring bank's responsibility. The Bank has already floated the tender and completed technical evaluation. There are 1800 branches, out of which 25 branches are targeted to be covered in the first phase. This way, the Bank has a task of computerizing more than 4000 branches. Ernst & Young has been appointed as bank's consultant for this project, whereas the technology partner is yet to be decided.

It is needless to say that, in the present scenario of banking, IT is the backbone for a banking company, and Indian public sector banks are fast accepting this reality. With immense competition from private players, there is a strong need to offer 24/7 services to customers. To a good banker and willing to expand its business by heaps and bounds, the decision to make IT investment should not take much time, as it is the need of the hour. All banks are moving towards 24/7 services. The competition is tough, and service providers don't have an alternative.