Have I missed something obvious, or is there a bug in the mac version of this Method? Searching the net suggests there are issues with the GetOpenFilename method on a mac, but usually with the FileFilter argument. The issue seems clearly to be the MultiSelect argument - I get the same behaviour if all other arguments
but the script then fails at this line, with the message 'Run-time error '1004': Method 'GetOpenFilename' of object '_Application' failed'. Sub SaveAndEmailAcquisition () Dim OutApp As Object Dim OutMail As Object Dim StrBody As String Dim StrTo As String Dim. To achieve this I should be able to use: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=True) 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.
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. The following code line works OK: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=False) 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).
0 kommentar(er)
