In this video we'll demonstrate a new feature in IBM® Lotus® Symphony
TM 3. Visual Basic for Applications (VBA) is a programming language used in most Microsoft Office applications. In Lotus Symphony, you can edit and run Microsoft VBA code directly.
Welcome
To read a text version of this video, scroll down to the
Welcome section in this wiki article.
To watch the video, click the play button.
Watch the demonstration full screen in a new window
Table 1. Welcome
Step | Caption |
1.1 | In this video we'll demonstrate a new feature in IBM Lotus Symphony 3.
Visual Basic for Applications (VBA) is a programming language used in most Microsoft Office applications. In IBM Lotus Symphony, you can edit and run Microsoft VBA code directly.
© Copyright IBM Corporation 2010 |
| 1.2 | In this demo, we'll edit the VBA code of an Excel file using Lotus Symphony and test that code. |
Opening an Excel macro
Table 2. Opening an Excel macro
Step | Caption |
2.1 | Let's right-click on the file VBAExample.xls, select Open With and then select IBM Lotus Symphony. We'll click OK when we see messages about the macro. |
Editing the macro
Table 3. Editing the macro
Step | Caption |
3.1 | In Lotus Symphony, we can edit VBA macros on the Basic editor. So we open the Macros window from the main menu and select the macro that we want. The Basic editor opens. |
3.2 | Now we can add our code. In this demo, our code creates a spreadsheet and sets the content of one cell to the current time and date. |
Testing the macro
Table 4. Testing the macro
Step | Caption |
4.1 | Once our code is ready we'll click to compile the code and run this macro. |
| 4.2 | You can see that the view is automatically switched to the Lotus Symphony main window, and a new spreadsheet is opened with the content of cell A1 modified. |
Thank you
Step: 5.1
Caption: Thank you for watching this demo. For more information visit the Lotus Symphony wiki.
IBM, the IBM logo, and ibm.com are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at
Copyright and trademark information at www.ibm.com/legal/copytrade.shtml.
Microsoft is a trademark of Microsoft Corporation in the United States, other countries, or both.