You could try 'Barkeeper's Friend'. It is a powdered cleanser similar to Comet, but much milder. I have used it on other vehicles with very good success (windshield only, of course). Haven't needed to use it on the Pilot yet, but wouldn't hesitate to try it.
If it is oil it does not need an abrasive like steel wool to get it off.
It needs a solvent.
Start with windex, if that does not work try rubbing alcohol.
Then maybe paint thinner.
The trick is to find the right solvent.
Keep it off the paint and rubber parts as much as posible.
Steel wool on a windshield is NUTS.:13:
Same goes for sandpaper if you had to ask.:14:
If you have an Autozone near by -- get yourself
a bottle of Eagle One 20/20. Should take care
of most films
If there are no Autozones, but there is a PepBoys,
get Stoner's Invisible Glass. Same or better.
If neither works -- try the Barkeeper, as someone
suggested, or BonAmi. Should not be neccessary
though unless you have tuff water spots.
Finally, if all else fails (because you've used
RainX or some such crap) -- get a bottle of
lighter fluid. It should strip just about anything. Just let it sit on the glass for a
last week I used Stoner's Invisible Glass. It worked great both inside and out. My wife liked it so much I lost a full can to her for inside the house. I've got a 12 year old car I tried it on and it cleaned everything off both the inside and outside of the windshield (except of course for the pits and chips). I ordered directly from their web site; but have heard it is available in some retail stores. It is worth a try.