Im getting a run time error "438" message on my Apple Mac Pro

Please Login or Register  to view this content.

'
Hello

I put together a down loader program to download stock quotes from the yahoo finance site, in excel 2007 on a windows based CPU, but when I go to run the same excel file on my Apple Mac Pro, using Excel 2016, I am getting an error message stating RunTime Error "438". I listed the VBA code below that works fine on my windows based computer but will not run on my Apple Mac Pro without the error message appearing. Does anyone have any suggestions for a fix to resolve this issue? Any help is much appreciated. Thanks in advance.

Please Login or Register  to view this content.

Hi, welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add them for you - this time

the code is ok in 2016 on mac for me

I only looked at the second code because you said that's where the error was ;-P

you need to remove these from the first part:

Please Login or Register  to view this content.

and 437 isn't a valid value for .TextFilePlatform on mac office. I think you can only use 1 2 or 3