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

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