Home

Compile Error, Method or data member not found

%3CLINGO-SUB%20id%3D%22lingo-sub-694161%22%20slang%3D%22en-US%22%3ECompile%20Error%2C%20Method%20or%20data%20member%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694161%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20the%20attached%20spreadsheet%20to%20get%20financial%20performance%20data%20from%20Yahoo%20but%20am%20seeing%20a%20Compile%20Error%2C%20Method%20or%20Data%20Member%20not%20found.%26nbsp%3B%20I%20am%20only%20seeing%20this%20when%20the%20macro%20is%20run%20on%20a%20mac.%26nbsp%3B%20Any%20advice%20or%20help%20would%20be%20really%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20all!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mconnolly31
Occasional Contributor

Hi,

 

I have created the attached spreadsheet to get financial performance data from Yahoo but am seeing a Compile Error, Method or Data Member not found.  I am only seeing this when the macro is run on a mac.  Any advice or help would be really appreciated.

 

Thanks all!