devxlogo

Tip Bank

Quick Recordset Copy to Excel Workbook

One of the most common things VB programmers do with Excel is load data into an Excel worksheet from a Recordset object. The method I see used most often to

Obtain a Regional Decimal Character Without an API

Use this function to read a number decimal symbol from regional settings: Sub Form_Load()Dim DecS As StringDecS = ReadDecimalSymbol()End SubFunction ReadDecimalSymbol() As StringReadDecimalSymbol = Mid$(CStr(1.1), 2, 1)End Function

Retrieve File Descriptions

This routine takes a passed filename as an argument and generates a description for it. It returns the same string as Windows Explorer does when it has been set to

Trim the Contents of the Text Box

This tip will trim the contents in the input box of an HTML page using java script. Call the Trim function by sending the Textbox element as the parameter. Example: