There are a number of problems associated with creating a spreadsheet that works on Apple macs and Windows which can select and open files using a 'open file' dialog box • Difficulty in creating a fileopen dialog box for macs • Error 1004 returned when refreshing a queryTable after the filename has been changed • Writing vba that works on both OSs given the range of functions that are required on one, but generate fatal errors on the other. The following code provides solutions to most of these problems, opening three text files using tableQueries based on the name of one of the files that is found using a find file dialog box. Browser specific fileopen dialog box The following is the Windows version of the code for opening a dialog box for selecting a file Function BrowseWin(mypath As String) With Application.FileDialog(msoFileDialogOpen).InitialFileName = GetDir(mypath) If.Show = -1 Then BrowseWin =.SelectedItems.Item(1) Else BrowseWin = '-' End If End With End Function And this is for macs: The fileopen dialog box on a mac is. This script catches errors within the Apple script and returns the error number as text (which always begins with a '-') allowing the calling code to decide what to do.

This catches 'errors' such as clicking the cancel button and opening with a directory that does not exist. I was not able to identify detailed error info if I caught the error in the VBA.

I'm creating a macro in Excel 2011 for Mac to create reports. Part of the macro wants to open a file (99% of the time), edit the file, and then close the file (saving changes). On a rare occasion, if a file does not exist, it wants to create a new excel file, edit it, and then close the file (saving changes).

Snapseed is a complete and professional photo editor developed by Google. == KEY FEATURES== • 29 Tools and Filters, including: Healing, Brush, Structure, HDR, Perspective (see list below). Snapseed for Mac OS is the only photo app you'll want to use every day! It makes any photograph extraordinary with a fun high-quality photo experience right on the desktop. Anyone can enhance, transform, and share their photos with ease using incredibly advanced features from the leader in digital photography software! Snapseed for mac. Snapseed for mac free download - WinZip Mac, WinZip Mac, AVG AntiVirus for Mac, and many more programs. Snapseed on the Mac is an impressive photo-editing program that stays true to its successful iOS predecessor.