1 / 114

Visual Basic for Applications

Explore the capabilities and limitations of spreadsheet software like Microsoft Excel and Google Spreadsheets, and how they compare to Visual Basic for Applications (VBA). Discover the programming aspect of Excel with VBA, and the power of Javascript-based formulas in Google Spreadsheets.

alexandera
Télécharger la présentation

Visual Basic for Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Visual Basic for Applications https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  2. Comparison of spreadsheet software Google spreadsheets • The capabilities of the spreadsheet have been perceived to be quite limited in comparison to, for example, Microsoft Excel. Google spreadsheet does not allow the use of named variables, and until recently had nothing comparable to Excel's programming feature (Visual Basic for Applications), but now Google Spreadsheets supports Javascript-based formulas that are quite powerful and expressive. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  3. Microsoft Excel Basic operation • It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  4. Microsoft Excel VBA programming • The Windows version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of Visual Basic https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  5. Microsoft Excel Standard file-extensions • Module .xlv A module is written in VBA (Visual Basic for Applications) for Microsoft Excel https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  6. Microsoft Excel 1993 Excel 5.0 • With version 5.0, Excel has included Visual Basic for Applications (VBA), a programming language based on Visual Basic which adds the ability to automate tasks in Excel and to provide user-defined functions (UDF) for use in worksheets https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  7. IBM Lotus Symphony History • and includes enhancements such as new sidebars in its user interface and support for Visual Basic for Applications macros, OpenDocument Format 1.2, and OLE https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  8. Macro (computer science) Application macros and scripting • Visual Basic for Applications (VBA) is a programming language included in Microsoft Office. However, its function has evolved from and replaced the macro languages that were originally included in some of these applications. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  9. Microsoft Office 2008 for Mac Features • Microsoft Visual Basic for Applications is not supported in this version https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  10. Microsoft Office 2008 for Mac Limitations • The lack of Visual Basic for Applications (VBA) support in Excel makes it impossible to use macros programmed in VBA https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  11. Gnumeric • Pivot tables and Visual Basic for Applications macros are not yet supported. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  12. Arena (software) • Arena can be integrated with Microsoft technologies. It includes Visual Basic for Applications so models can be further automated if specific algorithms are needed. It also supports importing Microsoft Visio flowcharts, as well as reading from or outputting to Excel spreadsheets and Access databases. Hosting ActiveX controls is also supported. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  13. Microsoft Excel • Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It included calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  14. Microsoft Office • Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, OLE data integration and Microsoft Visual Basic for Applications scripting language https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  15. Microsoft Office - Compatibility • Microsoft supports Office for the Windows and OS X platforms. Beginning with Mac Office 4.2, the OS X and Windows versions of Office share the same file format, and are interoperable. Visual Basic for Applications support was dropped in Microsoft Office 2008 for Mac, then reintroduced in Office for Mac 2011. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  16. LibreOffice - LibreOffice Basic • LibreOffice Basic is a programming language similar to Microsoft Visual Basic for Applications (VBA) but based on StarOffice Basic. It is available in Writer, Calc and Base. It is written in functions called subroutines or macros, with each macro performing a different task, such as counting the words in a paragraph. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  17. Spreadsheet - Functions • In Microsoft Excel these functions are defined using Visual Basic for Applications in the supplied Visual Basic editor, and such functions are automatically accessible on the worksheet https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  18. Visual Basic • A dialect of Visual Basic, Visual Basic for Applications (VBA), is used as a macro or scripting language within several Microsoft applications, including Microsoft Office. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  19. Visual Basic - Derivative languages • Visual Basic for Applications (VBA) is included in many Microsoft applications (Microsoft Office), and also in many third-party products like SolidWorks, AutoCAD, WordPerfect Office 2002, ArcGIS, Sage 300 ERP, and Business Objects Desktop Intelligence https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  20. Microsoft Visual Studio - Visual Studio 2005 • Microsoft also announced Visual Studio Tools for Applications as the successor to Visual Basic for Applications (VBA) and VSA (Visual Studio for Applications) https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  21. Microsoft Visual Studio - Visual Studio 2012 • Unlike prior versions, Visual Studio 2012 can't record and play back Visual Basic for Applications|macros and the macro editor is gone. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  22. Numbers (spreadsheet) - Other notable features • * Exports to Microsoft Excel, but lacks certain Excel features, including Visual Basic for Applications (absent in the 2008 version of Office for Mac, although it was reintroduced for the 2011 version) and pivot tables. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  23. Google Docs - Features • Google Spreadsheets and Google Sites also incorporate Google Apps Script to write code within documents in a similar way to Visual Basic for Applications|VBA in Microsoft Office. The scripts can be activated either by user action or by a trigger in response to an event. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  24. System Architect (software) - Features • ** Visual Basic for Applications (VBA) for extending functionality https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  25. Internet Explorer shell - IE extensions • *iMacros: A web macro recorder enhancement that adds record and replay features as well as Visual Basic for Applications support to Internet Explorer.[http://www.iopus.com/imacros/ iMacros | Web Browser Scripting, Data Extraction and Web Testing] https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  26. Microsoft Access • Like other Microsoft Office|Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  27. Microsoft Access - Timeline • Access 95) became part of the Microsoft Office Professional Suite, joining Microsoft Excel, Word, and PowerPoint and transitioning from Access Basic to Visual Basic for Applications (VBA) https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  28. Microsoft Access - Uses • There are template (file format)|template databases within the program and for download from their [ http://office.microsoft.com/en-us/templates/default.aspx website]. These options are available upon starting Access and allow users to enhance a database with predefined tables, query language|queries, forms, reports, and macros. Database templates support Visual Basic for Applications|VBA code but Microsoft's templates do not include VBA code. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  29. Microsoft Access - Uses • Programmers can create solutions using the programming language Visual Basic for Applications|Visual Basic for Applications (VBA), which is similar to Visual Basic|Visual Basic 6.0 (VB6) and used throughout the Microsoft Office programs such as Microsoft Excel|Excel, Microsoft Word|Word, Microsoft Outlook|Outlook and Microsoft PowerPoint|PowerPoint https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  30. Microsoft Access - Features • Users can create tables, queries, forms and reports, and connect them together with Macro (computer science)|macros. Advanced users can use Visual Basic for Applications|VBA to write rich solutions with advanced data manipulation and user control. Access also has report creation features that can work with any data source that Access can access. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  31. StarOffice Writer - Proprietary components • * Macro Converter for converting Microsoft Office Visual Basic for Applications|VBA macros to StarOffice Basic https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  32. VBScript - Uses • When an organization licenses Visual Basic for Applications (VBA) from Microsoft, as companies such as Autodesk, StatSoft, Great Plains Accounting and Visio (subsequently acquired by Microsoft) have done, it is allowed to redistribute the full VBA code-writing and debugging environment with its product. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  33. VBScript - Language features • Event-driven forms are not supported as in Visual Basic or Visual Basic for Applications. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  34. Excel spreadsheet • 'Microsoft Excel' is a spreadsheet Application software|application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  35. Active Scripting - Uses and history • Active Scripting can also be used for general-purpose scripting, such as database programming, text-processing, rapid prototyping, and application macro/scripting programming; some applications use Active Scripting as the main automation method, others do not have a macro facility but the components are available for use via the API; or one may opt to add a language and/or tool not available by default, like programming Microsoft Excel in Perl or REXX rather than Visual Basic for Applications (VBA) or transferring data from a terminal emulator to word processor by way of a spreadsheet when they have dissimilar macro tools or none at all. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  36. Active Scripting - Uses and history • According to Microsoft and third-party documentation, Visual Basic for Applications (VBA) is a third default scripting engine and is part of the Windows installation and therefore present even if there is not an installation of Microsoft Office, WordPerfect Office, or other software packages that are VBA-programmable https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  37. Active Scripting - Deprecation • VSA was also meant to replace Visual Basic for Applications.[ http://www.codeproject.com/csharp/vsascripting.asp VSA scripting in .NET], by Mark Belles on The Code Project. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  38. IBM Lotus Symphony - History • and includes enhancements such as new Sidebar (computing)|sidebars in its user interface and support for Visual Basic for Applications macros, OpenDocument Format 1.2, and Object Linking and Embedding|OLE https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  39. OpenOffice.org - OpenOffice Basic • OpenOffice.org included OpenOffice Basic, a programming language similar to Microsoft Visual Basic for Applications (VBA). OpenOffice Basic was available in Writer, Calc and Base. OpenOffice.org also had some Microsoft VBA macro support. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  40. OpenOffice.org - OpenOffice.org 3 • On 13 October 2008, version 3.0 was released, featuring the ability to import (though not export) Office Open XML documents, support for ODF 1.2, improved Visual Basic for Applications|VBA Macro (computer science)|macros, and a native interface port for OS X. It also introduced the new Start Center. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  41. Pro/DESKTOP • The 2008 Express release also removed support for Visual Basic for Applications|VBA available in the 2001i version https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  42. TurboCAD - 3D CAD Product History • In 1999, SoftDev created a Visual Basic for Applications|VBA-based plug-in known as AnimationLab, which is now up to version 4. This plug-in module allows users to create scenarios using the Key Frames Editor, assign a soundtrack for each actor, calculate the sound scene taking into account distance to the actors, speed, and overall environment. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  43. Bricscad - Products • BricsCAD uses the Open Design Alliance .dwg|DWG libraries to read and write the .dwg|DWG file format made popular by the AutoCAD CAD package. BricsCAD implements the AutoLISP scripting language, Dialog Control Language|DCL, Visual Basic for Applications|VBA and BRX. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  44. ProgeCAD - Commercial CAD Software • The user interface emulates certain versions of AutoCAD, including floating toolbars and a command line supporting AutoLISP and Visual Basic for Applications|VBA scripting https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  45. AutoCAD - Extensions • AutoCAD supports a number of application program interface|APIs for customization and automation. These include AutoLISP, Visual LISP, Visual Basic for Applications|VBA, Microsoft .NET|.NET and ObjectARX. ObjectARX is a C++ class library, which was also the base for: (a) products extending AutoCAD functionality to specific fields; (b) creating products such as AutoCAD Architecture, AutoCAD Electrical, AutoCAD Civil 3D; or (c) third-party AutoCAD-based application. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  46. CATIA - Systems engineering • CATIA V5 and V6 can be adapted using Visual Basic for Applications[http://www.3ds.com/partners/partner-details/microsoft-corporation/?xtmc=VBAxtcr=1 Microsoft Corporation – Technology Partnership], 3DS website and C++ programming languages via CAA (Component Application Architecture), a component object model (COM)-like interface. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  47. MicroStation - History • Other features that were added were: Accusnap, Design History, models, unlimited undo, Visual Basic for Applications|VBA programming, .NET Framework|.Net interoperability, True Scale, and standard definitions for working units (as the new file format stored everything internally in meters, but can recognize rational unit conversions so that it can know the size of geometry)(some of these features were also available in Microstation 95 to Microstation J) https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  48. Novell Linux Desktop - OpenOffice.org Improvements • The Novell OpenOffice.org team, led by Michael Meeks (software developer)|Michael Meeks, managed to create reasonably solid support for Visual Basic for Applications|VBA macros in Microsoft Excel documents, and a new spreadsheet feature called Data Pilot which offers compatibility with Microsoft Excel Pivot Tables . https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  49. Apache OpenOffice - OpenOffice Basic • Apache OpenOffice includes OpenOffice Basic, a programming language similar to Microsoft Visual Basic for Applications (VBA). Apache OpenOffice has some Microsoft VBA macro support. OpenOffice Basic is available in Writer, Calc and Base. https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

  50. Text Object Model - History • When TOM was developed, it was influenced heavily by WordBasic, a macro language used within Word before Visual Basic for Applications|VBA (Microsoft Word#Word 1990 to 1995|Word 95 and previous releases) https://store.theartofservice.com/the-visual-basic-for-applications-toolkit.html

More Related