I don't thinks so, since without the wifi on, it's not going to be able to scan for networks to know they are there.
However, you could use something like Locale or Tasker or Setting Profiles which will allow you to turn the wifi off and on based on your current location. For example, my wifi is usually off, but turns on automatically as I get home or to the office, then of course it automatically connects to the network there.