Office For Mac Visual Basic



  1. Visual Basic Office For Mac
  2. Office 365 Mac Visual Basic
  3. Microsoft Visual Basic For Mac
Visual
Microsoft Office 2008 for Mac
Microsoft Office 2008 for Mac applications: Word, Excel, PowerPoint and Entourage on Mac OS X 10.5 Leopard
Developer(s)Microsoft
Initial releaseJanuary 15, 2008; 12 years ago
Stable release
Operating systemMac OS X 10.4.9 through macOS 10.14.6
TypeOffice suite
License
Websitewww.microsoft.com/mac/products/Office2008/default.mspx
System requirements[2]
CPUPowerPC G4 or G5
(500 MHz or faster)
or any Intel processor
Operating systemMac OS X10.4.9 through 10.14.6
RAM512 MB
Free hard disk space1.5 GB
Optical driveDVD-ROM (for local installation)
NotesUnofficially runs on PowerPC G3 Macs (like the iMac G3 in Bondi Blue) and with less RAM
  1. Visual Basic (my preferred option) seems not to be present at all in Outlook 2016 on Mac!! I can't even find the VB editor (while I do find it for e.g. AppleScript might allow to do that. But I just do not find any documentation on the outlook API. Plus, it seems to only allow very basic automation.
  2. To begin, click Tools Macro Visual Basic Editor. On the Tools menu, click VBAProject Properties (In Word, click Project Properties ), and then click the General tab. In the Project Name box, enter the name that identifies your component in the registry of the Object Browser.

Next version of Mac Office to include important elements of Visual Basic According to a press release issued by Microsoft’s Macintosh Business Unit Tuesday, Office 2008, which debuted at this year’s MacWorld Expo in January, was the biggest release of the productivity suite for the Mac platform ever. Open Microsoft Visual Basic On Mac Microsoft Office 2008 For Mac 12.2 0 Update Mac Turn Off Scroll Sound Microsoft Arc Ouse Microsoft Office Change Theme Mac Reinstall Microsoft Word Mac 2014 Does Microsoft Office Professional Plus 2016 Work On Mac Microsoft Casual Games For Mac Microsoft Word Shortcut Mac Dock Mac Microsoft Office Recent Files.

Microsoft Office 2008 for Mac is a version of the Microsoft Officeproductivity suite for Mac OS X. It supersedes Office 2004 for Mac (which did not have Intel native code) and is the Mac OS X equivalent of Office 2007. Office 2008 was developed by Microsoft's Macintosh Business Unit and released on January 15, 2008. Office 2008 was followed by Microsoft Office for Mac 2011 released on October 26, 2010, requiring a Mac with an Intel processor and Mac OS version 10.5 or better. Office 2008 is also the last version to feature Entourage, which was replaced by Outlook in Office 2011. Microsoft stopped supporting Office 2008 on April 9, 2013.

Release[edit]

Microsoft on Tuesday announced it would restore support for Visual Basic for Applications (VBA) to Microsoft Office for Mac, a direct result of complaints from users about the removal of the suite.

Office 2008 was originally slated for release in the second half of 2007; however, it was delayed until January 2008, purportedly to allow time to fix lingering bugs.[3] Office 2008 is the only version of Office for Mac supplied as a Universal Binary.

Unlike Office 2007 for Windows, Office 2008 was not offered as a public beta before its scheduled release date.[4]

Features[edit]

Office 2008 for Mac includes the same core programs currently included with Office 2004 for Mac: Entourage, Excel, PowerPoint and Word.

Mac-only features included are a publishing layout view, which offers functionality similar to Microsoft Publisher for Windows, a 'Ledger Sheet mode' in Excel to ease financial tasks, and a 'My Day' application offering a quick way to view the day's events.[5]

Office 2008 supports the new Office Open XML format, and defaults to saving all files in this format. On February 21, 2008 Geoff Price revealed that the format conversion update for Office 2004 would be delayed until June 2008 in order to provide the first update to Office 2008.[6]

Microsoft Visual Basic for Applications is not supported in this version.[7] As a result, such Excel add-ins dependent on VBA, such as Solver, have not been bundled in the current release.[8] In June 2008, Microsoft announced that it is exploring the idea of bringing some of the functionality of Solver back to Excel.[9] In late August 2008, Microsoft announced that a new Solver for Excel 2008 was available as a free download from Frontline Systems, original developers of the Excel Solver.[10][11] However, Excel 2008 also lacks other functionality, such as Pivot Chart functionality, which has long been a feature in the Windows version. In May 2008, Microsoft announced that VBA will be making a return in the next version of Microsoft Office for Mac.[12]AppleScript and the Open Scripting Architecture will still be supported.

Limitations[edit]

Error message in Microsoft Excel showing features that are not supported

Office 2008 for Mac lacks feature parity with the Windows version. The lack of Visual Basic for Applications (VBA) support in Excel makes it impossible to use macros programmed in VBA. Microsoft's response is that adding VBA support in Xcode would have resulted in an additional two years added to the development cycle of Office 2008.[13] Other unsupported features include: OMML equations generated in Word 2007 for Windows,[14] Office 'Ribbon', Mini Toolbar, Live Preview, and an extensive list of features are unsupported such as equivalent SharePoint integration with the Windows version. Some features are missing on Excel 2008 for Mac, including: data filters (Data Bars, Top 10, Color-based, Icon-based), structured references, Excel tables, Table styles, a sort feature allowing more than three columns at once and more than one filter on a sort.

Benchmarks suggest that the original release of Office 2008 runs slower on Macs with PowerPC processors, and does not provide a significant speed bump for Macs with Intel processors.[15]

A using a program to remove application support files in unwanted languages), and which do not affect Office's operations, but which cause the updaters' installers to believe that the application is not valid for update. A small modification to the installer has been found an effective work-around (see reference).[18]

Another widespread problem reported after SP1 is that Office files will no longer open in Office applications when opened (double-clicked) from the Mac OS X Finder or launched from other applications such as an email attachment. The trigger for this problem is that Microsoft in SP1 unilaterally and without warning deprecated certain older Mac OS 'Type' codes such as 'WDBN' that some files may have, either because they are simply very old, or because some applications assign the older Type code when saving them to the disk. Users have seen the problem affect even relatively new Type codes, however, such as 'W6BN'. Microsoft is apparently looking into the problem, but it is unclear if they will reinstate the older Type codes, citing security concerns.[19]

Another problem with cross-platform compatibility is that images inserted into any Office application by using either cut and paste or drag and drop result in a file that does not display the inserted graphic when viewed on a Windows machine. Instead, the Windows user is told 'QuickTime and a TIFF (LZW) decompressor are needed to see this picture'. A user presented one solution as far back as December 2004.[20]

A further example of the lack of feature parity is the track changes function. Whereas users of Word 2003 or 2007 for Windows are able to choose freely between showing their changes in-line or as balloons in the right-hand margin,[21][22] choosing the former option in Word 2004 or Word 2008 for Mac OS also turns off all comment balloons; comments in this case are visible only in the Reviewing Pane or as popup boxes (i.e. upon mouseover).[23] This issue has not been resolved to date and is present in the latest version of Word for the Mac, namely Word 2011.[24]

The toolbox found in Office 2008 also has problems when the OS X feature Spaces is used: switching from one Space to another will cause elements of the Toolbox to get trapped on one Space until the Toolbox is closed and reopened. The only remedy for this problem is to currently disable Spaces, or at least refrain from using it whilst working in Office 2008.[25] Microsoft has acknowledged this problem and states that it is an architectural problem with the implementation of Spaces. Apple has been informed of the problem, according to Microsoft.[26] The problem appears to be caused by the fact that the Toolbox is Carbon-based.[citation needed] Using Microsoft Office with Mac OS X 10.6 Snow Leopard solves some of the problems.[26]

In addition, there is no support for right to left and bidirectional languages (such as Arabic, Hebrew, Persian, etc.) in Office 2008,[27][28] making it impossible to read or edit a right to left document in Word 2008 or PowerPoint 2008. Languages such as Thai are similarly not supported, although installing fonts can sometimes allow documents written in these languages to be displayed.

Moreover, Office 2008 proofing tools support only a limited number of languages (Danish, Dutch, English, Finnish, French, German, Italian, Japanese, Norwegian, Portuguese, Spanish, Swedish, and Swiss German).[29] Proofing tools for other languages failed to find their way to the installation pack, and are not offered by Microsoft commercially in the form of separately sold language packs. At the same time, Office applications are not integrated with the proofing tools native to Mac OS X 10.6 Leopard.

Microsoft Visio is not available for OS X. This means that any embedded Visio diagrams in other Office documents (e.g. Word) cannot be edited in Office on the Mac. Embedded Visio diagrams appear as a low-quality bitmap both in the WYSIWYG editor and upon printing the document on the Mac.

Editions[edit]

Comparison of different editions of Office 2008 for Mac
Applications and servicesHome & StudentStandardBusiness EditionSpecial Media Edition
WordYesYesYesYes
PowerPointYesYesYesYes
ExcelYesYesYesYes
EntourageYesYesYesYes
Exchange Server supportNoYesYesYes
Automator ActionsNoYesYesYes
Office Live and SharePoint supportNoNoYesNo
Expression MediaNoNoNoYes

See also[edit]

References[edit]

  1. ^'Microsoft Support Lifecycle - Office 2008'. Microsoft. Retrieved February 10, 2018.
  2. ^'Microsoft Office 2008 for Mac Specs'. CNET. January 15, 2008. Retrieved January 5, 2017.
  3. ^'It's Coming: Mac BU Announces Intent to Deliver Office 2008 for Mac'. Microsoft. January 9, 2007. Archived from the original on October 11, 2007.
  4. ^'Microsoft Office 2008 for the Mac delayed until January 2008'. TUAW. August 2, 2007.
  5. ^'Microsoft starts testing Office 2008 for Mac'. Cnet. April 2, 2007. Archived from the original on September 28, 2007. Retrieved September 19, 2007.
  6. ^'MS Office Mac Discussion Board'. January 15, 2008.
  7. ^'Saying goodbye to Visual Basic'. August 8, 2006.
  8. ^'MS Office Mac Discussion Board'. January 15, 2008.
  9. ^'Excel 2008 and Solver'. June 26, 2008.
  10. ^'Solver For Excel 2008 Is Available'. August 29, 2008.
  11. ^'Solver is Back for Microsoft Excel 2008 on Macintosh'. August 29, 2008.
  12. ^'Microsoft Office Update, and Visual Basic for Applications to Return - Mac Rumors'. May 13, 2008.
  13. ^'MS Mactopia Blog'. March 13, 2008.
  14. ^Known issues in Word 2008 – Equations saved from Word 2007 for Windows do not appear in Word 2008 for Mac
  15. ^'MS Mactopia Blog'. March 13, 2008.
  16. ^'CambridgeSoft Website'.
  17. ^New installer for 12.0.1 (The Entourage Help Blog)
  18. ^MacFixit article: More Fixes for Problems InstallingArchived January 26, 2009, at the Wayback Machine
  19. ^http://www.microsoft.com/mac/help.mspx?target=0b9aa757-50ab-443b-8b0e-3a50ece1d5451033&clr=99-4-0
  20. ^'Archived copy'. Archived from the original on June 26, 2008. Retrieved June 30, 2008.CS1 maint: archived copy as title (link)
  21. ^'Archived copy'. Archived from the original on July 2, 2009. Retrieved July 9, 2009.CS1 maint: archived copy as title (link)
  22. ^'IT training – IT training – IT Services – Administrative and academic support divisions – Services and divisions – Staff and students – Home'. Ittraining.lse.ac.uk. May 7, 2010. Archived from the original on February 27, 2009. Retrieved May 30, 2010.
  23. ^[1][dead link]
  24. ^http://officeformac.com/ms/ProductForums/Word/11634/0
  25. ^Bugs & Fixes: Office 2008 and Leopard’s Spaces don’t mix, Macworld, December 8, 2008
  26. ^ abOffice 2008 for Mac and Mac OS X Spaces, Microsoft
  27. ^Help and How-To for Microsoft for Mac Office Products | Mactopia
  28. ^Higgaion » It’s official: no RTL support in Microsoft Office 2008 for Mac
  29. ^Proofing tools that are available for each language

External links[edit]

Visual Basic Office For Mac

  • MacBU interview: Office 2008 Exchange Server support[permanent dead link]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Microsoft_Office_2008_for_Mac&oldid=955650181'

Office 2011 for Mac’s Visual Basic Editor (VBE) is very much like a specialized word processor combined with an organization tool and some special tools to help you make visual basic code. To display the VBE using the Ribbon, click the Developer tab, and in the Visual Basic group, and click Editor. From the menu bar, choose Tools→Macro→Visual Basic Editor.

Office 365 Mac Visual Basic

Mac

The VBE has menus, toolbars, and keyboard shortcuts, but there is no Ribbon. As with Office applications, VBE toolbars and menus are context sensitive.

As with Office applications, you can turn VBE interface components on and off using the View menu. Be sure to toggle on the Debug, Edit, and Standard toolbars as shown. Notice that keyboard shortcuts are displayed on the View menu.

The Standard toolbar in VBE, in Office 2011 for Mac

Some of the controls on the Standard toolbar in VBE are familiar text-editing controls. The rest are specific to working within the VBE.

  • Host Application: Takes you out of the VBE and displays the document, spreadsheet, or presentation view.

  • Insert: Inserts into the current Project a new UserForm, Module, Class Module, or Procedure. This button remembers which you inserted last and offers the most recently used as its default.

  • Save: Saves the document, workbook, or presentation of the Project that is currently selected in the Project Explorer.

  • Cut, Copy, Paste, and Find: Work similar to other applications.

  • Run: Click into a module (procedure) and then click Run to run your code.

  • Break: Interrupts code execution. Click Run or press F5 to resume, or click Step Over on the Debug toolbar to execute one command at a time.

  • Reset: When in Break mode, Reset ends the break and resets so that if you click Run again, code execution starts at the beginning.

  • Design Mode: In Design mode, the Break and Reset commands are disabled.

  • Project Explorer: Switches focus to the Project Explorer.

  • Properties Window: Displays the Properties window.

  • Object Browser: Displays the Object Browser.

  • Help: Displays VBA help.

  • Line and Column: You can think of a code module as a grid, with each character that you type at a specific location (line and column) within the grid. The cursor’s position is always displayed here. This is blank if your selection cursor is not in a code module.

The VBE Edit toolbar in Office 2011 for Mac

This toolbar focuses on editing code and making it easier to read with indenting.

  • Indent/Outdent: Applies to selection. Indenting is not automatic.

  • Breakpoint toggle: Adds or removes a breakpoint at the selection and is represented by a circle in the margin. If you run code, execution halts at a breakpoint. Press F5 or click Run to resume. Clicking in the margin adds a breakpoint. Clicking a breakpoint in the margin removes it.

  • Comment/Uncomment: Comment turns selection into a comment, which is text that does not execute when run.

  • Bookmark Toggle: Sets or removes a bookmark, represented by an oval in the margin.

  • Next Bookmark/Previous Bookmark: Navigation for bookmarks.

  • Clear All Bookmarks: Removes all bookmarks from the module.

The Office 2011 for Mac VBE Debug toolbar

The VBE Debug toolbar shares several tools in common with the Standard and Editing toolbars.

Microsoft Visual Basic For Mac

  • Step Into: Sets code execution at the first line of code.

  • Step Over: Executes one line of code each time it is pressed. This is the same as Command-Shift-O.

  • Step Out: Stops code executing. Same as Command-Shift-T.

  • Immediate Window: Displays the Immediate Window, where you can enter a code snippet followed by a question mark to see its result.

  • Call Stack: Displays the Call Stack dialog, an advanced debugging tool that you won’t need to worry about until you’re an expert.