Virtual Router / Wireless Hotspot using your PC

To host a Virtual Router / Access Point with your PC, you need a compatible Wireless Adapter that supports Hosted Network.



  • Windows 7 or later
  • Wireless Network adapter with HostedNetwork support.


Check for hosted network support by running this in Command Prompt:

netsh wlan show drivers


If it says No, your network card does not support Hosted Network, or you need to update your drivers.


Configure the wireless Hosted Network settings:

netsh wlan set hostednetwork ssid=MySSID key=MyWiFiKey

You will only need to do this once. It will retain this settings even if you reboot your PC.


Start the wireless Hosted Network (Run as Administrator):

netsh wlan start hostednetwork


Stop the wireless Hosted Network:

netsh wlan stop hostednetwork


Set up Internet Connection Sharing (ICS)

Next, bring up the properties window of the Network Adapter that has Internet Connection.


Check “Allow other network users to connect through this computer’s Internet connection”. Now select the Network Adapter to share to (in my case, HostedNetwork).


Once properly configured, your Hosted Network Status should show Internet connectivity.



Supported Devices

Unsupported Network Adapters
Intel® PRO/Wireless 3945ABG Network Connection
Intel® Wireless WiFi Link 4965AGN
Intel® Centrino® Wireless-N 100
Intel® Centrino® Wireless-N 130


Not Supported Devices



More Information

Excel VBA: RsLinx DDE example

'Initialize DDE
channelNumber = Application.DDEInitiate("RSLinx", "SomeTopicName")

'Read from PLC5
readValue = DDERequest(channelNumber, "N20:1")
'Read from ControlLogix
readValue = DDERequest(channelNumber, "ControlLogixTag[1]")

'Write to PLC
Set rangeToPoke = Worksheet("Sheet1").Range("A1")

'Write to PLC5
Application.DDEPoke channelNumber, "N20:2", rangeToPoke
'Write to ControlLogix
Application.DDEPoke channelNumber, "ControlLogixTag[1]", rangeToPoke

'End DDE
Application.DDETerminate channelNumber

Excel VBA: Excel Version

Use Application.Version property to find out the version of Microsoft Excel. Useful to check for Microsoft Excel version to test the number of rows.

Example Syntax:

MsgBox (Application.Version)

Version Number:

  • 15.0 – 2013
  • 14.0 – 2010
  • 12.0 – 2007
  • 11.0 – 2003


Known Names & Versions

  • Intellution FIX32 v6.15
  • Intellution FIX32 v7.0
  • Intellution iFix 2.21
  • Intellution iFix 2.5/2.6
  • Intellution iFix 3.0
  • GE FANUC iFix 3.5
  • GE FANUC iFix 4.5
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.0
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.1
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.5

External Links: