Steuben Trust Company – Apply for loans, banking, and financial services at www.steubentrust.com Steuben Trust Company is a well-known banking services provider in Western, Southern, and New York Tiers. It has been in service since 1902. Steuben Trust Company provides banking and financial services for businesses and individuals (personal). Apart from that, it also deals […]
Calling the Excel VBA SpecialCells method on a single cell will return special cells of the specified type for the entire worksheet. The function below will return a range of specified special cells for a worksheet, range or a single cell. This is the workbook I used to test with.
Typically you can launch files, webpages, and generate emails using Excel’s FollowHyperlink method (I think the same method is available in all Office products). For some reason, I was getting nasty Excel crashes using it recently, so I switched to using a Windows API alternative. PrivateConstm_sSource AsString= “modShell”‘http://msdn.microsoft.com/en-us/library/windows/desktop/bb762153(v=vs.85).aspxPrivateConstSHELL_ERROR = 32 ‘If the function succeeds, it returns a value greater […]
In the past the only thing available for calling web services was Microsoft’s Soap Toolkit. In order to use this component, you would have to redistribute the OCX. Unfortunately, the toolkit hasn’t been updated since 2003 and is no longer supported. IMHO it was cumbersome to use anyway. The class I wrote uses MSXML’s XMLHTTP to do all the […]