Information générale
Catégorie:
Codage, syntaxe et commandes
Is there a function that will tell me what field type a memory variable is? I have an activeX control getting information from a spreadsheet and the field type is either character or numeric. I need to know what type it is.
Here is the line that captures the data
Tmp = oXL.ActiveSheet.Cells(TmpSVRow,1).VALUE
I am doing an IF statement and I need it to be a character field. Here is the if statement beginning. I have few lines that are numeric.
IF ALLTRIM(Tmp) = "Runoff Balance Book"
Thanks for your help
Todd
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement