I think the only way you're going to get it to work is if your computer supports internet sharing over wifi. I doubt the Wii will be able to connect using the modem.
If you have a Mac, it's easy to turn on internet sharing...go into system prefs > sharing > then make sure internet sharing is...