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:

Flash Player for Android

Flash Player for Android 2.x, 3.x, 4.x.

Adobe Flash Player is not officially supported on Android 4.1+ JellyBean, but you can still install it on your JellyBean.

Supported Browsers

  • Android Browser
  • Firefox Browser for Android
  • Firefox Beta
  • Maxthon Android Web Browser

Unsupported Browsers

  • Google Chrome

Untested

  • Dolphin
  • Firefox Beta by Mozilla
  • Maxthon Web Browser for Tablet by Maxthon LTD

Instructions

  1. Enable installation from Unknown Sources.
  2. Get the latest APK:
    http://helpx.adobe.com/flash-player/kb/archived-flash-player-versions.html

Wireless Laptop Card

Wireless LANWiFi ProtocolWiFi Max. Speed(Transmit/Receive)
MIMO
Form FactorYear IntroducedFeatures
Intel® PRO/Wireless 2100b11 MbpsMiniPCI: IIIA, IIIB2003
Intel® PRO/Wireless 2100Aa, bMiniPCI: IIIB2003
Intel® PRO/Wireless 2200BGb, g54 MbpsMiniPCI: IIIB2004
Intel® PRO/Wireless 2915ABG a, b, g54 MbpsMiniPCI: IIIB2005
Intel® PRO/Wireless 3945ABG a, b, g54 MbpsPCIe MiniCard2006
Intel® Wireless WiFi Link 4965AGNa, b, g, n(2.4/5)300/300 Mbps
2x3:2
PCIe MiniCard2007
Intel® Centrino® Wireless-N 100b, g, n(2.4)150/150 Mbps
1x1:1
PCIe Half MiniCard2011Wi-Fi Direct™
Intel® My WiFi Technology
Intel® Centrino® Wireless-N 105b, g, n(2.4)150/150 Mbps
1x1:1
PCIe Half MiniCard2012Wi-Fi Direct™
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 130b, g, n(2.4)150/150 Mbps
1x1:1
PCIe Half MiniCard2011Wi-Fi Direct™
Bluetooth 3.0+HS
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 135b, g, n(2.4)150/150 Mbps
1x1:1
PCIe Half MiniCard2012Wi-Fi Direct™
Bluetooth 4.0 Low Energy
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 1000b, g, n(2.4)150/300 Mbps
1x2:2
PCIe MiniCard
PCIe Half MiniCard
2011Wi-Fi Direct™
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 1030b, g, n(2.4)150/300 Mbps
1x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
Bluetooth 3.0+HS
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 2200b, g, n(2.4)300/300 Mbps
2x2:2
PCIe Half MiniCard2012Wi-Fi Direct™
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N 2230b, g, n(2.4)300/300 Mbps
2x2:2
PCIe Half MiniCard2012Wi-Fi Direct™
Bluetooth 4.0 Low Energy
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Wireless-N + WiMAX 6150b, g, n(2.4)150/300 Mbps
1x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
WiMAX
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Advanced-N 6200a, b, g, n(2.4/5)300/300 Mbps
2x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Advanced-N 6205a, b, g, n(2.4/5)300/300 Mbps
2x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Advanced-N 6230a, b, g, n(2.4/5)300/300 Mbps
2x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
Bluetooth 4.0 Low Energy
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Advanced-N 6235a, b, g, n(2.4/5)300/300 Mbps
2x2:2
PCIe Half MiniCard2012Wi-Fi Direct™
Bluetooth 4.0 Low Energy
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Advanced-N + WiMAX 6250a, b, g, n(2.4/5)300/300 Mbps
2x2:2
PCIe Half MiniCard2011Wi-Fi Direct™
WiMAX
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Intel® Centrino® Ultimate-N 6300a, b, g, n(2.4/5)450/450 Mbps
3x3:3
PCIe Half MiniCard2011Wi-Fi Direct™
Intel® Wireless Display
Intel® Smart Connect Technology
Intel® My WiFi Dashboard
Dell Wireless 1350b, g54 MbpsMiniPCI
Dell Wireless 1450a, b, g54 MbpsMiniPCI
Dell Wireless 1501
(Broadcom)
b, g, n(2.4)72/72 Mbps
1x1:1
PCIe Half MiniCard
Dell Wireless 1505
Dell Wireless 1506
(Atheros AR5B125)
b, g, n(2.4)150/150 Mbps
1x1:1
PCIe Half MiniCard
Dell Wireless 1510
Dell Wireless 1520
Dell Wireless 1530a, b, g, n(2.4)300/300 Mbps
2x2:2

Computer Name in Taskbar.

My boss wanted to put a name on the desktop (floating) or taskbar so that he knows which machine is he working on (Virtual Machine, Host Machine or Remote Desktop). Here’s what I found which is simply brilliant;

  1. Right-Click your Taskbar
  2. Click Toolbars –> New Toobar…
  3. Right Click in the empty space, Click New -> Folder, and give your New Folder a Name. Example: ZY-I5-PC
  4. Click Select Folder

Credits: http://www.hanselman.com/blog/WindowsTipEasilyShowYourComputerNameInTheTaskbar.aspx

Result:

image

DD-WRT: OpenVPN

OpenVPN is easy to configure on the newer DD-WRT firmwares.

On the DD-WRT revision 18946M, there is a Netmask bug (refuse to accept new Netmask), enter the Netmask in Router (TUN) Server Mode before switching to Bridge (TAP) Server Mode.

Use this OpenVPN guide to generate the required certificates: http://openvpn.net/index.php/open-source/documentation/howto.html#pki

Notice that I’m using TCP port 443, that allows me to bypass some firewalls 😉

Excel VBA: Speed up macro execution

Speed up macro execution by turning off screen updating/flicker.

'Turn Off Screen Updating
Application.ScreenUpdating = False
'Optional: Refresh/Update screen manually when needed
Application.ScreenRefresh

'Your Code

'Turn On Screen Updating
Application.ScreenUpdating = True

Excel VBA: Check for Comments

'If Comment does not exist
 If Range("B4").Comment Is Nothing Then
 Range("B4").Value = "Does not exist."
 End If

 'If Comment exist
 If Not Range("C4").Comment Is Nothing Then
 Range("C4").Value = Range("C4").Comment.Text
 End If

Posts navigation

1 2 3