Forum Discussion
'Run-time error '1004': Method 'GetOpenFilename' of object '_Application' failed' on MacOs
Greetings! I'm writing some VBA code for selecting a specified file in order to retrieve info from it and paste into destination. I use GetOpenFilename method, however on running I get the above ...
I have the same problem, I had to run Excel in a Windows VM on my MAC to solve it..... there're other problems too with Excel for MacOS, data segmentation problems...