MICROSOFT EXCEL PROGRAMMING
It is a sophisticated programming language that enables you to control any and all aspects of the program. Anything you can do with the keyboard and mouse you can also do with programming.
Advantages
SAVE TIME.
REDUCING ERRORS
ENFORCING STANDARDS
INTEGRATE WITH OTHER APPLICATIONS
Programming Fundamentals
CREATE INSTRUCTIONS OR FLOW CHART BEFORE CREATING A PROGRAM.
HANLING DATA
◦ DATA STORED OUTSIDE THE PROGRAM.
◦ DATA STORED WITHIN THE PROGRAM.
WHAT IS VBA LANGUAGE?
VBA stands for Visual Basic for Applications. The name Visual Basic for Applications reflects the fact that VBA is based on Microsoft’s Visual Basic programming language, and that it is designed for programming within applications—
VBA Editor is a platform to write Excel programs. It can open by pressing Alt+F11 when in Excel, or by selecting Tools➪Macro➪
Topics covered are:
• Advance EXCEL
• Macros
• Access
• SQL
• VBA 2007 Programming
# # #
High Technologies Solutions is a training n placement organization.High Technologies Solutions is a leading Training Institute in Data Warehousing, Mainframe, AS400, Synon, J2EE, .NET, SQT(Testing)
Photo:
http://www.prlog.org/




