Could you please throw out all the irrelevant stuff (like calls to Win32::OLE) and construct a small, runnable example that demonstrates your problem?

$HPLC_Collum seems not to contain the number 18, you don't need Win32::OLE to find that out.

Also please Use strict and warnings.