VBA Rapid Application Development Library

Semantic Interface for Enabling Ontology Landscaping of Data

•The SemCode uses the two function call types to set and get data from a dynamic array of worksheets semantically. The SemCode Library contains a set of routines to simplify progress in Microsoft’s back office.

•ColumnName2Long(dWks As String, dCol As String)

•ColumnName2Letter(dWks As String, dCol As String)

•ColNumber2Letter(iCol As Long)

•op(dTF As Boolean)

•YN2TF(dYN As String)

•TF2YN(dTF As Boolean)

•SheetExists(sWSName As String)

•CopyFile(fPth As String, tPth As String)

•MoveFile(fPth As String, tPth As String)

•FileExists(fPth As String)

•IsFileOpen(FileName As String)