VBÃüÃû¹æÔò¼°´úÂë¹æ·¶
VBA
ÃüÃû¹æÔò¼°´úÂë¹æ·¶
Âíά·å
(maweifeng@263.net
)
1.
VBA
ÃüÃû¹æÔò
Ò»¸öºÃµÄÃüÃû¹æÔò¿ÉÒÔÌá¸ß³ÌÐòµÄ¿É¶ÁÐÔ£¬¼õÉÙ´íÎó·¢ÉúµÄ¸ÅÂÊ£¬ÃüÃû¹æÔò²»ÊÇÒ»¶¨µÄ£¬²»Í¬µÄÈËÓв»Í¬µÄ¹æÔòºÍϰ¹ß£¬µ«ÔÚ±à³Ì¹ý³ÌÖУ¬¶ÔÓÚ¸öÈË»ò¹¤×÷×飬һ¶¨Òª×ñÊØÏàͬµÄÃüÃû¹æÔò¡£
1.1.
±äÁ¿¡¢³£Á¿¡¢×Ô¶¨ÒåÀàÐͺÍö¾Ù
±í
1
‑1
¸ÅÀ¨Á˱äÁ¿¡¢³£Á¿µÄ»ù±¾ÃüÃû¹æÔò¡£
±í
1
‑
1
±äÁ¿¡¢³£Á¿ºÍö¾ÙÀàÐ͵ÄÃüÃû¹æÔò
ÔªËØ
ÃüÃû¹æÔò
±äÁ¿
<
·¶Î§
><
Êý×é
><
Êý¾ÝÀàÐÍ
>
ÃèÊö£¨Ê××Öĸ´óд£©
³£Á¿
<
·¶Î§
><
Êý¾ÝÀàÐÍ
>
ÃèÊö£¨È«²¿´óд£©
Óû§×Ô¶¨ÒåÀàÐÍ
Type
ÃèÊöÃû³Æ
<
Êý¾ÝÀàÐÍ
>
ÃèÊö
End Type
ö¾ÙÀàÐÍ
Enum <
¹¤³Ìǰ׺
>
Ò»°ãÃèÊö
<
¹¤³Ìǰ׺
><
Ò»°ãÃèÊö
><
¾ßÌåÃû³Æ
1>
<
¹¤³Ìǰ׺
><
Ò»°ãÃèÊö
><
¾ßÌåÃû³Æ
2>
End Enum
<
·¶Î§
>
±íʾÁ˱äÁ¿µÄ×÷ÓÃÓò£¬¶ÔÓÚ
Private
ÀàÐͺÍÄ£¿é¼¶±äÁ¿£¬Ò»°ãʹÓÓ
m
”ǰ׺±íʾ£¬¶ÔÓÚ
Public
ÀàÐ͵ıäÁ¿£¬Ò»°ãʹÓÓ
g
”ǰ׺±íʾ£¬¶ø¶ÔÓÚ¹ý³ÌÄڵľֲ¿±äÁ¿£¬Ôò²»Ê¹ÓÃǰ׺¡£Èç¹ûÊÇÊý×飬ÔÚ·¶Î§Ç°×ººóÔö¼Ó“
a
”±íʾ±äÁ¿ÎªÊý×é¡£
¶ÔÓÚÊý¾ÝÀàÐÍ£¬Ò»°ãʹÓÃ
±í
1
‑2
µÄǰ׺±íʾ¡£
±í
1
‑
2
ÃüÃû¹æÔò³£ÓÃǰ׺
ǰ׺
Êý¾ÝÀàÐÍ
ǰ׺
Êý¾ÝÀàÐÍ
ǰ׺
Êý¾ÝÀàÐÍ
is
Boolean
cm
ADODB.Command
cmb
MSForms.ComboBox
byt
Byte
cn
ADODB.Connection
chk
MSForms.CheckBox
cur
Currency
rs
ADODB.Recordset
cmd
MSForms.CommandButton
dte
Date
fra
MSForms.Frame
dec
Decimal
cht
Excel.Chart
lbl
MSForms.Label
f
Double
£¬
Single
rng
Excel.Range
lst
MSForms.ListBox
i
Integer
£¬
Long
wb
Excel.Workbook
mpg
MSForms.MultiPage
obj
Object
ws
Excel.Worksheet
opt
MSForms.OptionButton
str
String
spn
MSForms.SpinButton
u
User-defined type
cbr
Office.CommandBar
txt
MSForms.TextBox
v
Variant
ctl
Ïà¹ØÎĵµ£º
vb class Property Get¡¢Property Let ʹÓÃ
<%
'ÔÚ Class ¿éÖУ¬³ÉԱͨ¹ýÏàÓ¦µÄÉùÃ÷Óï¾ä±»ÉùÃ÷Ϊ Private(˽ÓгÉÔ±£¬Ö»ÄÜÔÚÀàÄÚ²¿µ÷ÓÃ) »ò Public(¹«ÓгÉÔ±£¬¿ÉÒÔÔÚÀàÄÚÍⲿµ÷ÓÃ) ¡£
'±»ÉùÃ÷Ϊ Private µÄ½«Ö»ÔÚ Class ¿éÄÚÊǿɼûµÄ¡£±»ÉùÃ÷Ϊ Public ²»½öÔÚ Class ¿éµÄÄÚ²¿ÊǿɼûµÄ£¬¶Ô Class ¿éÖ®ÍâµÄ´úÂëÒ²Êǿɼûµ ......
Ò»¡¢ VB¶ÁдEXCEL±í£º
¡¡¡¡VB±¾ÉíÌá×Ô¶¯»¯¹¦ÄÜ¿ÉÒÔ¶ÁдEXCEL±í£¬Æä·½·¨ÈçÏ£º
¡¡¡¡1¡¢ÔÚ¹¤³ÌÖÐÒýÓÃMicrosoft ExcelÀàÐͿ⣺
¡¡¡¡´Ó"¹¤³Ì"²Ëµ¥ÖÐÑ¡Ôñ"ÒýÓÃ"À¸£»Ñ¡ÔñMicrosoft Excel 9.0 Object Library£¨EXCEL2000£©£¬È»ºóÑ¡Ôñ"È·¶¨"¡£±íʾÔÚ¹¤³ÌÖÐÒªÒýÓÃEXCELÀàÐͿ⡣
¡¡¡¡2¡¢ÔÚͨÓöÔÏó ......
'**************************¶ÁͼƬÎļþ**************************************
Sub GetPicfromDB(cn As ADODB.Connection)
On Error Resume Next
Dim ......
³¤¾ÃÒÔÀ´£¬ÓÉÓÚ²»ÄÜÖ±½Ó»ñµÃVBÀà³ÉÔ±º¯ÊýÖ¸Õ룬ÒòΪÎÞ·¨ÔÚVBµÄÀàÄ£¿éÖÐÖ±½ÓʹÓö¨Ê±Æ÷¿Ø¼þ»ò¶¨Ê±Æ÷API£¬»ùÓÚ°³±àдµÄ»ñµÃÀà³ÉÔ±º¯ÊýÖ¸ÕëµÄº¯Êý£¬°³±àдÁËÕâ¸ö´ø¶¨Ê±Æ÷¹¦ÄܵÄÀ࣬ϣÍû¸øÅóÓÑÃÇһЩÆô·¢¡£
Ò»¡¢Ð½¨Ò»¸öÀ࣬ÀàÃû³ÆÎªclsTimer£¬Àà´úÂëÈçÏ£º
Option Explicit
'* ** ......