VBA Code not working from Windows to Mac

[arsenal123gunners]

Hi there, I used the following code on a Windows computer using Excel 2013, and it worked great, but when I try it on my Mac using Excel 2011, i get a "object does not support this property or method" error for PreserveFormatting, RefreshPeriod, WebSelectionType, etc.

Any way I can fix this issue, or another code that would solve my problem? Thanks for your help.

Code:

[mikerickson]

You can use conditional compilation.

Please Login or Register  to view this content.

In your situation, it might look like

Please Login or Register  to view this content.

[arsenal123gunners]

I am still getting errors. Do you know why I am getting an error on .PreserveFormatting, or .RefreshPeriod? Is the coding different on Mac versus PC?

[mikerickson]

Those properties are not supported in Excel 2011.
Similarly, neither ActiveX controls or the Dictionary object is supported for Mac Excel.
When you find a property that isn't supported by Mac, conditional compiling can avoid compile errors.

[arsenal123gunners]

Do you know a code that I would be able to use to get the data on Mac that I was previously getting on Windows?

[mikerickson]

What data?

[arsenal123gunners]

The tables I'm trying to pull from baseball-reference.com. If it won't work with the code above, how can I change that code so it will work?