3/17/2024 0 Comments Excel for mac vba correlationHave 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 Keychain Access program is a tool that can be used to view passwords to documents. Use Keychain Access to Recover Excel Password on Mac. The issue seems clearly to be the MultiSelect argument - I get the same behaviour if all other arguments Free Excel Password Remover for Mac - ZIP Software. but the script then fails at this line, with the message 'Run-time error '1004': Method 'GetOpenFilename' of object '_Application' failed'. To achieve this I should be able to use: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=True) 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |