Do you know what causes this weird behavior, and how to solve it?Ģ. The various updates and versions are designed so that there will be no issue with the Microsoft Office including Word, PowerPoint, Outlook, and other MS office applications. Though, your XLOOKUP file does work when opening it anew and doing nothing with it.ġ. So, if you are experiencing an issue like Microsoft word application is not responding to Mac, you might need to work out a little bit more.
What is more, when I type the French equivalent of XLOOKUP, which is RECHERECHEX in the formula bar, the pop up box suggests RECHERCHE, RECHERCHEH and RECHERCHEV, but not RECHERECHEX, as if it was unknown. Note that if I type your formula in your spreadsheet, it returns #NAME?.Īnd if I drag drop down with the cross from the right bottom corner your XLOOKUP cell, the new cells at the bottom also return #NAME? 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.Yes, when I open the XLOOKUP file you sent me, it does work, and I get '3' as a result.īut when I noticed that you added '_xlfn.' in the beginning of the formula (=_xlfn.XLOOKUP(F3 B4:B9 C4:C9 ""), I wanted to copy it, in order to ask you why, but XLOOKUP stopped working and returned #NAME? instead of '3'. 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'.
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 formula continues to show the old value even after youve changed the values of the dependent cells.
The following code line works OK: NewFileNames = Application.GetOpenFilename(Title:="Locate latest download files", ButtonText:="Choose", MultiSelect:=False) Symptoms: The value returned by your Excel formula does not update automatically, i.e. 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)
