![excel for mac vba filesaveas excel for mac vba filesaveas](https://i.stack.imgur.com/9PPYB.png)
The issue seems clearly to be the MultiSelect argument - I get the same behaviour if all other arguments Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see. but the script then fails at this line, with the message 'Run-time error '1004': Method 'GetOpenFilename' of object '_Application' failed'. Excel VBA Macros for Beginners These 15 novice macros provides the easiest way to understand and learn the basics of VBA to deal with Excel Objects. To achieve this I should be able to use: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=True) folderpath 'Autumn:Tim:TestFolder:' & filename -Activeworkbook.Saveas filename:folderpath. I have tried several configurations to try to get the file saved properly. 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. I am trying to save a file (.xls) to a server (Autumn). The following code line works OK: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=False) Sub SaveAndEmailAcquisition () Dim OutApp As Object Dim OutMail As Object Dim StrBody As String Dim StrTo As String Dim.
![excel for mac vba filesaveas excel for mac vba filesaveas](https://i.stack.imgur.com/sRCgW.png)
In the video above I highlight some of the many new improvements to the editor. The new VB Editor contains a lot of the features we are used to seeing in the Windows versions of Excel, or Excel 2011 for Mac.
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). The VBA below works 100 fine with PC users but since Mac's have a few different variances when it comes to File Path's I'm running into an issue of them using my form to save the file when clicking a button assigned with VBA. Microsoft just released a new build of Excel that contains a new VB Editor, which we use to write VBA macros in Excel.