ÿþ<HTML> <HEAD> <meta http-equiv="Content-Language" content="cs"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1250"> <title>VBA code</title> </HEAD> </P> <TABLE WIDTH="100%" ALIGN=CENTER CELLSPACING="0" BORDER="0"> <TR> <TD width="27%" align="LEFT" bordercolordark="#000000"><HR><P></TD> <TD ALIGN=CENTER>&nbsp;<P></TD> <TD ALIGN=CENTER>&nbsp;<P></TD> </TR> </TABLE> <style> <!-- a {text-decoration:none} a {color:RED} a {cursor: crosshair;} a:hover {color:WHITE} BODY { SCROLLBAR-FACE-COLOR:"#282828"; SCROLLBAR-HIGHLIGHT-COLOR:"SaddleBrown"; SCROLLBAR-SHADOW-COLOR:"LightSlateGray"; SCROLLBAR-3DLIGHT-COLOR:"LavenderBlush"; SCROLLBAR-ARROW-COLOR:"LightSlateGray"; SCROLLBAR-TRACK-COLOR:"LightSlateGray"; SCROLLBAR-DARKSHADOW-COLOR:"GRAY"; } --> </style> <body leftmargin="0" topmargin="0" marginwidth="0" marginheigt="0" link="BLACK" vlink="BLACK" alink="#C0C0C0" text="LavenderBlush"> <div align="left"> <body bgcolor="#111111"> <TABLE WIDTH="100%" ALIGN=CENTER CELLSPACING="0" BORDER="0"> <TR> <TD ALIGN="LEFT"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT></b></p> </TD> <font face="Arial CE, Helvetica CE, Arial, Helvetica, sans-serif"> <TD ALIGN="LEFT"><b> <font color="LavenderBlush" style="font-size: 14pt">Variables and Prefixes <p align="LEFT"><font color="LavenderBlush" style="font-size: 10pt"> <font face="Arial CE, Helvetica CE, Arial, Helvetica, sans-serif"> <table width="576" bordercolor="#FF9900" border="1" cellspacing="0" cellpadding="0" bgcolor="111111"> <tr vAlign="top"> <td height="42" width="74" valign="middle" bgcolor="#111111" align="center"><font face=" Arial, Helvetica" size="2" color="#FFFFFF"><b>Data type</b></font></td> <td height="42" width="228" valign="middle" bgcolor="#111111" align="center"><b><font face=" Arial, Helvetica" size="2" color="#FFFFFF">Description</font></b></td> <td height="42" width="322" valign="middle" bgcolor="#111111" align="center"><b><font face=" Arial, Helvetica" size="2" color="#FFFFFF">Range</font></b></td> </tr> <tr vAlign="top"> <td height="21" width="74" align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">Byte</font></b></td> <td height="21" width="228">1-byte binary data</td> <td height="21" width="322">0 to 255</td> </tr> <tr vAlign="top"> <td height="21" width="74" align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">Integer %</font></b></td> <td height="21" width="228">2-byte integer</td> <td height="21" width="322"> 32,768 to 32,767</td> </tr> <tr vAlign="top"> <td height="21" width="74" align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">Long &</font></b></td> <td height="21" width="228">4-byte integer</td> <td height="21" width="322"> 2,147,483,648 to 2,147,483,647</td> </tr> <tr vAlign="top"> <td height="70" width="74" align="center" valign="middle" rowspan="2"><b><font face=" Arial, Helvetica" size="2">Single !</font></b></td> <td height="70" width="228" valign="middle" rowspan="2">4-byte floating-point number</td> <td height="35" width="322"> 3.402823E38 to  1.401298E  45 (negative values)</td> </tr> <tr vAlign="top"> <td height="35" width="322"><font face=" Arial, Helvetica" size="2">1.401298E  45 to 3.402823E38 (positive values)</font></td> </tr> <tr vAlign="top"> <td width="74" align="center" valign="middle" rowspan="2"><b><font face=" Arial, Helvetica" size="2">Double #</font></b></td> <td width="228" valign="middle" rowspan="2">8-byte floating-point number</td> <td width="322"> 1.79769313486231E308 to<br>  4.94065645841247E  324 (negative values)</td> </tr> <tr vAlign="top"> <td width="322"><font face=" Arial, Helvetica" size="2">4.94065645841247E  324 to 1.79769313486231E308 (positive values)</font></td> </tr> <tr vAlign="top"> <td height="24" width="74" align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">Currency @</font></b></td> <td height="24" width="228" valign="middle">8-byte number with fixed decimal point</td> <td height="24" width="322" valign="middle"> 922,337,203,685,477.5808 to 922,337,203,685,477.5807</td> </tr> <tr vAlign="top"> <td height="21" width="74" align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">String $</font></b></td> <td height="21" width="228" valign="middle">String of characters</td> <td height="21" width="322" valign="middle">Zero to approximately two billion characters</td> </tr> <tr vAlign="top"> <td align="center" valign="middle"><b><font face=" Arial, Helvetica" size="2">Date</font></b></td> <td valign="middle">8-byte date/time value </td> <td valign="middle">January 1, 100 to December 31, 9999 </td> </tr> </table> </center> </td> </tr> </table> <BR> <BR> <BR> <table border="0" width="660"> <tr> <td width="100%" align="center"> <table border="1" width="406" bordercolor="#FFFFFF"> <tr> <td width="117" bgcolor="#111111""><b><font color="#FFFFFF">Data Type</font></b></td> <td width="99" bgcolor="#111111"" align="center"><b><font color="#FFFFFF">Prefix</font></b></td> <td width="168" bgcolor="#111111""><b><font color="#FFFFFF">Example</font></b></td> </tr> <tr> <td width="117" bgcolor="#111111">Boolean</td> <td width="99" bgcolor="#111111" align="center">bln</td> <td width="168" bgcolor="#111111">blnFound</td> </tr> <tr> <td width="117" bgcolor="#111111">Byte</td> <td width="99" align="center" bgcolor="#111111">byt</td> <td width="168" bgcolor="#111111">bytTracks</td> </tr> <tr> <td width="117" bgcolor="#111111">Date/Time</td> <td width="99" bgcolor="#111111" align="center">dtm</td> <td width="168" bgcolor="#111111">dteStartOfShift</td> </tr> <tr> <td width="117" bgcolor="#111111">Double</td> <td width="99" bgcolor="#111111"align="center">dbl</td> <td width="168" bgcolor="#111111">dblDistance</td> </tr> <tr> <td width="117">Error</td> <td width="99" align="center">err</td> <td width="168">errCantOpen</td> </tr> <tr> <td width="117" bgcolor="#111111">Integer</td> <td width="99" bgcolor="#111111"align="center">int</td> <td width="168" bgcolor="#111111">intNbrOfStudents</td> </tr> <tr> <td width="117">Long</td> <td width="99" align="center">lng</td> <td width="168">lngPopulation</td> </tr> <tr> <td width="117" bgcolor="#111111">Object</td> <td width="99" bgcolor="#111111"align="center">obj</td> <td width="168" bgcolor="#111111">objConnection</td> </tr> <tr> <td width="117">Single</td> <td width="99" align="center">sng</td> <td width="168">sngAge</td> </tr> <tr> <td width="117" bgcolor="#111111">String</td> <td width="99" bgcolor="#111111"align="center">str</td> <td width="168" bgcolor="#111111">strCountryName</td> </tr> <tr> <td width="117" bgcolor="#111111">Currency</td> <td width="99" bgcolor="#111111" align="center">cur</td> <td width="168" bgcolor="#111111">curHourlySalary</td> </tr> <tr> <td width="117" bgcolor="#111111">Variant</td> <td width="99" bgcolor="#111111"align="center">var</td> <td width="168" bgcolor="#111111">varFullName</td> </tr> </table> </td> </tr> </table> </FONT></b></p></TD> <BR><P> </TD> <TD ALIGN="LEFT"><b> <p align="LEFT"><font color="LavenderBlush" style="font-size: 14pt"> </FONT> <p align="LEFT"><font color="LavenderBlush" style="font-size: 10pt"> </TD> </TR> </TABLE> <p align="RIGHT">Main &nbsp; <a href="http://tf.czu.cz/~ales/vba">+</a>&nbsp; &nbsp; &nbsp; &nbsp; <p align="RIGHT"><font color="SILVER" style="font-size: 8pt"> 2006 &nbsp; &nbsp; </BODY> </HTML>