MS EXCEL MACROS OR VBA (Virtual Basic Application) |
Sebutan Tanggal
e.g. 10/03/2008 menjadi tanggal
tiga bulan oktober tahun dua ribu delapan |
File ini terdiri atas tiga sheet: Common Variables yang digunakan antara lain strSTRING untuk menyinpan string, strTERBILANG untuk menyimpan isi Terbilng, intLOOP untuk iterasi, intROW untuk menunjukkan row yang sedang di proses dan intLENGTH untuk menyimpan panjang string atau data. Input Data variables yang digunakan antara lain intROWDATA menunjukkan row data yang sedang di proses, intSTOPDATA sebagai variable untuk menunjukkan kapan data sudah habis, strSEBUTANTANGGAL untuk menyimpan hasil konversi sebutan tanggal, stsrDATA untuk menyimpan tanggal yang akan di konversi dan datDATA untuk menyimpan tanggal. Sub procedure yang digunakan adalah: Sub Auto_Open() READ DATA sampai habis atau intSTOPDATA > 10 lebih dari
10 row yang kosong Sub sfiTERBILANG01() Sub sfiTERBILANG02(strNUMBER As String) |
Free Posting IKLAN GRATIS,
send your name, address, telephone, email id, website and brief description
of your business to AdminTebetbarat.com
|
Option Explicit Statement Dim Statement Part Description When not explicitly stated in lower, the lower bound of an array is
controlled by the Option Base statement. The lower bound is zero if
no Option Base statement is present. Remarks Variables declared with Dim at the module level are available to all procedures within the module. At the procedure level, variables are available only within the procedure. Use the Dim statement at module or procedure level to declare the data type of a variable. For example, the following statement declares a variable as an Integer. Dim NumberOfEmployees As Integer Also use a Dim statement to declare the object type of a variable. The following declares a variable for a new instance of a worksheet. Dim X As New Worksheet If the New keyword is not used when declaring an object variable, the variable that refers to the object must be assigned an existing object using the Set statement before it can be used. Until it is assigned an object, the declared object variable has the special value Nothing, which indicates that it doesn't refer to any particular instance of an object. You can also use the Dim statement with empty parentheses to declare a dynamic array. After declaring a dynamic array, use the ReDim statement within a procedure to define the number of dimensions and elements in the array. If you try to redeclare a dimension for an array variable whose size was explicitly specified in a Private, Public, or Dim statement, an error occurs. If you don't specify a data type or object type, and there is no Deftype statement in the module, the variable is Variant by default. When variables are initialized, a numeric variable is initialized to 0, a variable-length string is initialized to a zero-length string (""), and a fixed-length string is filled with zeros. Variant variables are initialized to Empty. Each element of a user-defined type variable is initialized as if it were a separate variable. Note When you use the Dim statement in a procedure, you generally put the Dim statement at the beginning of the procedure.
[Private | Public | Friend] [Static] Sub name [(arglist)] End Sub Sub TEST() Statement LTrim, RTrim, and Trim Functions Replace Function The Replace function syntax has these named arguments: Part Description Settings The compare argument can have the following values: Constant Value Description Return Values Replace returns the following values: If Replace returns |
Free Posting IKLAN GRATIS,
send your name, address, telephone, email id, website and brief description
of your business to AdminTebetbarat.com
|