TechplusNJ.com

Software

LabVIEW

folderBrowser.vi - folder browser VI written in LabVIEW 8.5. LabVIEW has a file browser but not a folder browser so I wrote my own. This VI utilizes ActiveX Shell32 objects instead of calling DLL functions with Call Library Function Node.

ADO - LabVIEW programmers generally use ActiveX automation to read and write to Excel files. There are examples that ship with LabVIEW that explain how to do it. If there is a lot of data, writing to a range of cells at one time will be much faster that writing data one cell at a time. There is Visual Basic 6 code snippet at Methods for transferring data to Excel from Visual Basic that explains how to write an array of data at a time. This code snippet is easily ported to LabVIEW.

There is another way to read data from and write data to Excel from LabVIEW, and that is to use ADO (ActiveX Data Objects). Discussion on this topic can be found at How To Use ADO with Excel Data from Visual Basic or VBA. Again the code snippets are written in Visual Basic 6 which can be ported over to LabVIEW. There are many cautions in that article. The one bug that is of concern is the one discussed at BUG: Excel ODBC Driver Disregards the FirstRowHasNames or Header Setting regarding reading cell values from Excel. I found the solution was to use ACE OLEDB 12.0 driver which was released with Microsoft Office 2007. It will work even with Excel 2003 and earlier files. You do not need Office 2007 installed to get the driver. Install Microsoft Access Database Engine 2010 Redistributable from here.

read from Excel file [JPEG of VI block diagram] and write to Excel file [JPEG of VI block diagram]

HTML, CSS, PHP, MySQL

Open Microsoft Office documents in IE7 and IE8

Linux

my Linux adventures

PHP + MySQL

I have a website using this technology here.

ASP.NET + VB.NET + MySQL

I have a website using this technology here. With some web hosts, a Microsoft SQL Server database costs extra, but MySQL is generally included free. Connection to MySQL uses MySQL's Connector/NET driver available at MySQL.com. I use Microsoft Visual Web Developer 2010 Express.

Laptop repair

I refurbish laptops - specializing in Dells and early model IBM Thinkpads. Located in central NJ. Click here for a list of laptops for sale.

Unlock Dell BIOS for free

There is a Dell technician with the handle of Dell-Royan S at the Dell message boards who will unlock the BIOS for free. Normally, this would be a $50 charge, but he apparently has been bypassing the Dell rules about this, and is doing it for free. You will still have to prove ownership. Just another example of not all customers being treated equally. If you know where to post your complaint, you get "special" treatment. PM him through his profile: http://en.community.dell.com/members/dell_2d00_royan-s/default.aspx.

Upgrade Dell Latitude L400 BIOS without a floppy drive

Dell Latitude L400 BIOS update instructions using just the CDROM drive. The CDROM drive cannot be one connected to the USB port; it must be one that is connected to the L400's IDE connector for external media bay via Dell's proprietary cable. I bought this media cable on eBay. The CDROM drive can be any CDROM drive from the Dell Latitude C-series of laptops.

 

 

Available for work on freelance / contract basis

 

Bachelor of Science in Electrical Engineering [University of Illinois at Urbana-Champaign]
Master of Science in Electrical Engineering [University of Michigan at Ann Arbor]

 

Get your own email image at http://services.nexodyne.com/email/.