Can I make a wired connection appear as if it was connected wirelessly?

I have recently got a desktop PC and have it connected via an Ethernet cable to a Virgin Media Super Hub.

As it is a wired connection it is causing me a lot of problems, for example I can't connect to wireless printer and I can't transfer data from my phone to my pc via an address (such as 192.168.1.7, which I could do using iPhone Apps, and my laptop which was also connected to the Wi-Fi).

I was just wondering if there was a way I can make my computer appear as if it was connected to the wireless as oppose to being wired. Or if there's a way I can connect to my printer or addresses such as 192.168.1.7 so I can transfer files between my phone and PC.

Any help is much appreciated.

You can by a wire lesss ethernnet port USB device which is available isn market.

It shouldn't matter whether its connected wireless or wired. If they are on the same network that should be it. You need to make sure that your computers internal IP address is in the same range of the printer and phone. For example your printer if it is connected to wireless would have an IP address of 192.168.1.5, your computer if on the same network would be something like 192.168.1.7. Anything between 2 and 254 would be in the same network.

Your wireless printer needs to have a static IP address.

What you need to do is in your router, reserve a IP address for each device, that way whenever that device connects to the DHCP server in your router it will assign the same IP address to it every time.

That sounds odd as all the devices should be able to talk to each other, mine do and I didn't do anything special to set them up
That's because whether you use wired or wireless it makes no difference as that's just the physical connection. On top of that all of the devices will use Ethernet to talk to one another
I don't know how you've got this hub set up but are all of your devices have an IP address of 192.168.1.X?
Maybe you've set up a DMZ, have guest wireless or have firewalled off the wireless and wired networks so they can't talk to each other