Visual Basic for Applications
Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was declared legacy in 2008, and is an associated integrated development environment (IDE). Although pre-.NET Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications. As of 2020, VBA has held its position as "most dreaded" language for developers for 2 years, according to some who participated in surveys undertaken by Stack Overflow. (The most dreaded language for 2018 was Visual Basic 6).
Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word's WordBASIC. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
As its name suggests, VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library. However, VBA code normally can only run within a host application, rather than as a standalone program. VBA can, however, control one application from another using OLE Automation. For example, VBA can automatically create a Microsoft Word report from Microsoft Excel data that Excel collects automatically from polled sensors. VBA can use, but not create, ActiveX/COM DLLs, and later versions add support for class modules.
VBA is built into most Microsoft Office applications, including Office for Mac OS X (except version 2008), and other Microsoft applications, including Microsoft MapPoint and Microsoft Visio. VBA is also implemented, at least partially, in applications published by companies other than Microsoft, including ArcGIS, AutoCAD, CorelDraw, LibreOffice, Reflection, SolidWorks, WordPerfect, and UNICOM System Architect (which supports VBA 7.1).
Greater Manchester is a metropolitan county and combined authority area in North West England, with a population of 2.8 million; comprising ten metropolitan boroughs: Bolton, Bury, Oldham, Rochdale, Stockport, Tameside, Trafford, Wigan, and the cities of Manchester and Salford. Greater Manchester was created on 1 April 1974, as a result of the Local Government Act 1972, and designated a functional city region on 1 April 2011. Greater Manchester is formed of parts of the historic counties of Lancashire, Cheshire and the West Riding of Yorkshire.
Greater Manchester spans 493 square miles (1,277 km2), which roughly covers the territory of the Greater Manchester Built-up Area, the second most populous urban area in the UK. Though geographically landlocked, it is connected to the sea by the Manchester Ship Canal which is still open to shipping in Salford and Trafford. Greater Manchester borders the ceremonial counties of Cheshire (to the south-west and south), Derbyshire (to the south-east), West Yorkshire (to the north-east), Lancashire (to the north) and Merseyside (to the west). There is a mix of high-density urban areas, suburbs, semi-rural and rural locations in Greater Manchester, but land use is mostly urban—the product of concentric urbanisation and industrialisation which occurred mostly during the 19th century when the region flourished as the global centre of the cotton industry. It has a focused central business district, formed by Manchester city centre and the adjoining parts of Salford and Trafford, but Greater Manchester is also a polycentric county with ten metropolitan districts, each of which has at least one major town centre and outlying suburbs.
Greater Manchester is governed by the Greater Manchester Combined Authority (GMCA), which consists of political leaders from each of the ten metropolitan borough councils, plus a directly elected mayor, with responsibility for economic development, regeneration and transport. Andy Burnham is the inaugural Mayor of Greater Manchester, elected in 2017. For the 12 years following 1974, the county had a two-tier system of local government; district councils shared power with the Greater Manchester County Council. The county council was abolished in 1986 and so its districts (the metropolitan boroughs) effectively became unitary authority areas. However, the metropolitan county continued to exist in law and as a geographic frame of reference, and as a ceremonial county, with a Lord Lieutenant and a High Sheriff. Several county-wide services were co-ordinated through the Association of Greater Manchester Authorities between 1985 and 2011.
Before the creation of the metropolitan county, the name SELNEC was used for the area, from the initials of "South East Lancashire North East Cheshire". Greater Manchester is an amalgamation of 70 former local government districts from the former administrative counties of Lancashire, Cheshire, the West Riding of Yorkshire and eight independent county boroughs. Since deindustrialisation in the mid-20th century, Greater Manchester has emerged as a major centre for services, media and digital industries, and is renowned for guitar and dance music and its association football teams.