The CEO's speech had a great effect in me. vs The CEO's speech had a great effect on me.

Some examples from the web:

• This dream... this nightmare soon had a great effect on my life.
• The increase in the elderly population has had a great effect on the lives of women who, in general, when they are no longer looking after their children, have to look after their parents.
• My parents had a great deal of trouble raising me.
• No, not me. I knew they had a great football team.
• Because I thought we had a great time the night you got drunk and kissed me.
• It's true that Shawn did say some meaningful words that had a great deal of influence on me.
• It had a great part in it for me.
• I went out and had a great time last night, and you should be happy for me.
• Know this. I went out and had a great time last night, and you should be happy for me.
• - Dennis had a great idea.
• -Your mama had a great feeling last night.
• Lisa said you had a great fight.
• I haven't had a great year, but I have a trillion more days ahead of me.
• I've had a great, great ride, believe me.
• It's true that Shawn did say some meaningful words that had a great deal of influence on me.
• He said I had a great voice, and he'd like to record me.
• The pretty intern that caught the CEO's eye.
• So Amy's desk sits outside the CEO's office.
• And hope the CEO's tumors do the rest.
• I'm pretty sure we can charm the CEO's pants off.

Some examples from the web:

• This dream... this nightmare soon had a great effect on my life.
• The increase in the elderly population has had a great effect on the lives of women who, in general, when they are no longer looking after their children, have to look after their parents.
• It is clear that pollution has a great effect on human health.
• I don't know to explain this, but it makes a great effect on me coming back to a house in which I've already lived.
• My parents had a great deal of trouble raising me.
• This is one reason why the Commission should examine it for compliance with EU law and it could have a great effect on other Member States.
• Know this. I went out and had a great time last night, and you should be happy for me.
• It had a great part in it for me.
• It's true that Shawn did say some meaningful words that had a great deal of influence on me.
• Because I thought we had a great time the night you got drunk and kissed me.
• No, not me. I knew they had a great football team.
• I went out and had a great time last night, and you should be happy for me.
• Lisa said you had a great fight.
• Your mama had a great feeling last night.
• He said I had a great voice, and he'd like to record me.
• I haven't had a great year, but I have a trillion more days ahead of me.
• It's true that Shawn did say some meaningful words that had a great deal of influence on me.
• I've had a great, great ride, believe me.
• This would certainly have a great effect on the environment and sustainable development, as public contracts for goods and services constitute 14% of the EU's combined GNP, and up to 25% in some sectors.
• And for me China - I started photographing it four years ago, and China truly is a question of sustainability in my mind, not to mention that China, as well, has a great effect on the industries that I grew up around.