As the pixel count goes up, the distance goes down. I will shortchange you on the long explained and head to a known solution.
Read http://www.amazon.com/VGA-Over-CAT5-Extender-Audio/dp/B001PBO5YK
Hi:
I just bought a 50-ft VGA cable (15-pin) for a renovation I'm doing on my house (going to wire projector into ceiling). I'm currently using a fairly short (~6ft) 14-pin cable to connect my computer (Gateway laptop running windows XP) to my Mitsubishi HC1500 projector. That configuration worked fine. However, when I hooked my new cable up to test it (before burying it in a wall and a ceiling!) there is a problem with the image size. The edges of the computer's desktop are not visible on the projector's image. Dropping it down to 1024x768 works, but degrades the image quality on my laptop's screen.
What's the problem? Would a different cable (shorter, or some other number of pins) allow me to keep things as they were?
Thanks,
David

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic