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.

 

Requirement:

  • 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

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.

Local-Area-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).

Local-Area-Connection-Sharing

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

Hosted-Network-Status-Internet

 

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

iFix

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: