there is a new feature to do that in snow leopard called "wake on demand". but it only works with new computers that support it and only if your router is a recent time capsule or an airport extreme base station.
http://support.apple.com/kb/HT3774
This thread has been closed by the system or the community team.
You may vote for any posts you find helpful, or search the Community for additional answers.
Waking a sleeping mac
Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.