No spark but car cranks over

Possible crank sensor heat failing . When it stalls will it turn over at all ? If so have you checked for spark ?

Hi Greg, I'm AL the owner of Big As Auto Repair in St Charles Mo

Greg, I read your complete message, but nowhere did I see that you replaced the Cam Sensor. The EGR will cause it to stall at stops but usually will not prevent it from restarting. I would try replacing the Cam Sensor before anything else. If you should need further assistance go to my website by clicking here: Auto Repair

The cam sensor tells the ECM when to fire the plug. Might want to replace the sensor.

I don't really agree with the IAC idle air control valve however, you can test it by unplugging it while the car is running; if the valve is bad (assuming no bad wires or pcm problems) the engine will not change it's sound. On the other hand if it's good the engine will sputter and have an erratic idle but probably wont die...........
A common culprit of your cars condition is often a bad crank shaft or cam shaft position sensor; for most vehicles they are easy to change and only $10 or so. There are tests that can be done to check the parts and that another topic. The crank shaft position sensor is where I would start. And, as another person said the fuel filter is a good thing to replace; could be your problem, and it probably needs it anyway. Good luck and try and keep from throwing parts at her; work the problem don't let it work you.

the crank sensor is favorite they are unreliable that explaines why the trans not getting engine speed signal unless its a manual box and that code will allways be logged advise start by checking for water ingress in engine control module located lower rh a post then change crankshaft position sensor or better still try and borrow one from a good running car

Could be a dirty throttle body or a faulty idle air control valve.
Is the check engine light on ?

Crank shaft sensor or air mass meter, is this a v6? I had the 2,6 a4 same fault same miles funny enough. changed the air mass meter is was ok after that. thing is they have so many sensors, you need to get it on a diagnostic machine to be sure.

Honda is notorius for bad MAIN RELAYS the solder in them crack and can not be seen with the nacked eye. This is due to simple expansion & contraction the solder heats up & cools down. Try that.

change the module

Crank position sensor, roughly about £50 from mercedes.
jib
www.mercanic.co.uk