devxlogo

September 12, 2001

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