![excel for mac vba filesaveas excel for mac vba filesaveas](https://www.techonthenet.com/excel/macros/images/visual_basic_editor2011_005.gif)
The issue seems clearly to be the MultiSelect argument - I get the same behaviour if all other arguments The most popular versions among Microsoft Excel for Mac users are 14.0, 12.3 and 10.1. The program lies within Productivity Tools, more precisely Office Tools. but the script then fails at this line, with the message 'Run-time error '1004': Method 'GetOpenFilename' of object '_Application' failed'. This free Mac application is an intellectual property of Microsoft. In this code, the file name is given with the XLSX extension.
![excel for mac vba filesaveas excel for mac vba filesaveas](https://www.passfab.com/images/topics/excel/read-only-status.jpg)
Sub saveFile () ActiveWorkbook.SaveAs Filename:'D:\temp\myFile.xlsx', FileFormat:51 End Sub. In this case, you have to give a path and file name where the program should save the file. To achieve this I should be able to use: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=True) You can quickly save an XLSX file using this single line of code.
txt') If fileSaveName <> False Then MsgBox 'Save as ' & fileSaveName End If.fileSaveName Application.GetSaveAsFilename ( fileFilter:'Text Files (.txt). If the user chooses a file name, the example displays that file name in a message box. I recently had a user attempt to use it on a Mac and received the following error: Compile Error: Cant find project or library Which is the result of using the Tools > References > Microsoft Scripting Runtime library. The problem is that this allows selection of only one file (MultiSelect:=False), whereas I want users to be able to make more than one selection. This example displays the Save As dialog box, with the file filter set to text files. I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects. The following code line works OK: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=False)
![excel for mac vba filesaveas excel for mac vba filesaveas](https://i.stack.imgur.com/9PPYB.png)
#Excel for mac vba filesaveas mac osx
I'm writing an excel VBA script to run on a mac (Excel for Mac, version 15.17, mac OSX 10.11.2 El-Capitan).