AppleScriptTask in Office 2016 for the Mac In Office 2011 for the Mac there are many problems with the built-in VBA commands. For Example Dir, Kill, GetOpenFilename, GetSaveAsFileName and many others. F or example, in Office 2011 file names in VBA are limited to a maximum of 32 characters including the extension. If the file name is longer the code fails. VBA developers responded by using AppleScript in many situations to work around the problems. They also used AppleScript to do things that are not possible with VBA code; for example to email u sing VBA code, Excel 2011 and Outlook 2011.

In Office 2016, we need to use a new method and a new approach explained below. Example for Excel 2011 In Office 2011 we use the built-in MacScript function to run a script that we build up as a string in the VBA code. See the code example below. C opy the test macro and the function below into a normal module of your workbook.

Change the file path and name in the macro TestMacro to point to a file on your Mac to test.

Excel 2016 for Mac brings lots of welcome improvements to the workhorse spreadsheet but also leaves out useful tools. Moving to the cloud: Like the other apps in the latest Mac Office suite.

One of the advantages of doing the last Office 2016 product review is that I can leverage work others have done to save you, the reader, some redundant explanation. So if you haven’t yet, check out the reviews of,,. Much of what you’ll read about in those apps applies to, too: Mac-specific features like multi-touch gestures, full screen support, Retina graphics, a cleaned-up and easily-hidden ribbon, a fixed task pane that replaces floating palettes for formatting, integrated support for OneDrive, and excellent cross-platform file compatibility.

You can read more about these features in the above-mentioned reviews; they work just the same way in the new Excel. (As with the other apps, you can only presently get Excel 2016 if you’re an Office 365 subscriber.) What else is new When you launch Excel 2016, you’ll be greeted by Excel’s clean new appearance. You can choose from a colored header (new in 2016) or the usual gray header from previous releases.

Workbooks with multiple tabs get a much cleaner tab bar, losing the fake 3D appearance. Colored tabs are now colored with a thin bar, instead of a gradated fill on the entire tab, making it easier to read tab names. Overall, I found the new interface pleasant and easier to use than in older versions of Excel. Excel includes the Smart Lookup feature found in other Office apps.

When you create a table in Microsoft Excel for Mac and copy it into a new email message in Microsoft Outlook for Mac, the table is pasted into the email without any borders. Cause This is a known issue in Office 2011 for Mac and Office 2016 for Mac. Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut.

Smart Lookup uses Bing to show contextual information for a highlighted word—while this is undoubtedly useful in Word, I didn’t really find myself using it much while working on spreadsheets. But if you suddenly need to look up everything there is to know about the word “amortization,” Smart Lookup is ready for you. So what’s new and unique to Excel 2016? Quite a few things, starting with the removal of the Standard and Formatting toolbars. While you could hide these in Excel 2011, they’re completely gone—replaced by the task pane—in Excel 2016. I don’t miss them at all, as they were redundant and took up screen space.

Also new is greatly improved sharing. Save your file to OneDrive, and you can then use a sharing button to invite people via their email address, copy a link you can then email to others, or send the workbook as either a PDF or native workbook attachment.

Recipients can (assuming you grant permission) edit your file, even if they don’t own Excel, through Microsoft’s web-hosted Excel app. Fans of pivot tables will find a new slicer tool that greatly increases the usability of pivot tables. A slicer is a way to limit the data you see in a pivot table. In a pivot table showing years of sales by salesperson, for example, you can use slicers to restrict the table to one or more years, or to one or more salespeople. Slicers let you limit what you see in a pivot table; you can add one or more to really refine what you see. Here, only data from 2012, 2013, and 2015 is visible. Another “new” feature is the inclusion of the Analysis Toolpak add-on.

• Complete all classic video editing like crop, trim, cut, split and combine in a few clicks. • Supports almost all kinds of video formats, including MP4, AVI, MOV, AVCHD, MKV and more. Part 2: Best Video Editing Software for Beginners (Video Tutorial) Recommended: Wondershare Filmora for Mac offers some persuasive advantages over other video editing tools available for Apple Mac. It not only includes basic video editing tools but also provides various advanced video effects for you to apply. • Make your footage look like Hollywood film with color tuning tool.

Reading Email 2. Auto reply outlook for mac 2011. Setting Up Outlook • • • • • • • • • • 2. Reading Email • • • • • • • 3.