Ñ§Ï°Íø¿¼ÊÔѧϰ×ÊÁÏ

Gzu521.com

WordÖÐÀûÓÃVBA±à³ÌÖÆ×÷¿¼ÊÔÓÃ×÷ÎĸåÖ½(1)

°ì¹«Èí¼þ   µã»÷£º´Î   ·¢²¼Ê±¼ä£º2006-12-22   ¡¾×ÖÌ壺´ó ÖРС¡¿   À´Ô´£ºGzu521.com
GZU521.COMÑ§Ï°Íø
 

¡¡¡¡ÓïÎÄ¿¼ÊÔÖУ¬¾­³£Óõ½×÷ÎĸåÖ½£¬wordÖдøÓиåֽģ°å£¬µ«ÓÐÖî¶àÏÞÖÆ£¨ÈçÖ½ÐÍ¡¢ÐÐÁÐÊýµÈÏà¶Ô¹Ì¶¨£©£¬ÔÚÊÔ¾íÅŰæÊ±ÆÄΪ²»±ã¡£¾­¹ý³¢ÊÔ£¬±ÊÕßÕÒµ½Ò»ÖÖÀûÓÃwordµÄvba±à³Ì£¬Í¨¹ý»æÖƱí¸ñʵÏÖ¿¼ÊÔÓÃ×÷ÎĸåÖ½µÄ·½·¨¡£

¡¡¡¡Ò»¡¢±àÖÆ³ÌÐò WZ{yw;-2L_€$[$wHj [ ±¾ ×Ê ÁÏ À´ Ô´ ÓÚ ¹ó ÖÝ Ñ§ ϰ Íø µçÄÔ¿ÎÌð칫Èí¼þ http://Www.gzU521.com ] WZ{yw;-2L_€$[$wHj

¡¡¡¡1£®Æô¶¯word£¬Á¬Ðøµã»÷¡°¹¤¾ß¡±£¬¡°ºê¡±£¬¡°Â¼ÖÆÐºê...¡±£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÌîдºêÃû£¨´ËÀýΪ¡°×÷ÎĸåÖ½¡±£©£¬Ñ¡ÔñºêÒª±£´æµÄλÖ㨿ÉÒÔ±£´æÔÚÄ£°åÖУ¬Ò²¿ÉÒÔ±£´æÔÚµ±Ç°ÎĵµÖУ©£¬Èçͼ1Ëùʾ¡£

¡¡¡¡2£®ÎªÁË·½±ã²Ù×÷£¬¿ÉÒÔ½«´ËºêÒÔ°´Å¥µÄÐÎʽָ¶¨ÔÚ¹¤¾ßÀ¸ÖС£µ¥»÷¡°Â¼Öƺꡱ¶Ô»°¿òÖеġ°¹¤¾ßÀ¸¡±°´Å¥£¬ÔÚµ¯³öµÄ¡°×Ô¶¨Ò塱¶Ô»°¿òµÄÓҲ࣬ѡÖкêÃüÁî¡°normal.newmacros.×÷ÎĸåÖ½¡±£¬ÓÃÊó±ê½«ÆäÍ϶¯¸´ÖƵ½¡°³£Óá±¹¤¾ßÀ¸£¬ÔÚÆäÉϵ¥»÷ÓÒ¼ü£¬Ñ¡ÔñÏàÓ¦µÄÃüÁîÐÞ¸ÄÃû³Æ£¬ÎªÆä±à¼­Ò»¸öСͼ±ê£¬½á¹ûÈçͼ2Ëùʾ¡£

¡¡¡¡3£®µ¥»÷¡°Â¼Öƺꡱ¶Ô»°¿òÖеġ°¹Ø±Õ¡±°´Å¥£¬ÆÁÄ»ÉϽ«³öÏÖÒ»¸ö¡°Â¼Öƺꡱ¹¤¾ßÀ¸£¬µ¥»÷Í£Ö¹°´Å¥Í£Ö¹Â¼ÖÆ¡£

¡¡¡¡4£®ÒÀ´ÎÑ¡Ôñ¡°¹¤¾ß¡±¡¢¡°ºê¡±¡¢¡°ºê¡­¡±£¬ÔÚ¶Ô»°¿òÖÐÑ¡ÔñºêÃû¡°×÷ÎĸåÖ½¡±£¬µ¥»÷¡°±à¼­¡±°´Å¥£¬´ò¿ªvba±à³Ì´°¿Ú¡£Â¼ÈëÈçÏ´úÂ룺

sub ×÷ÎĸåÖ½()
    userform1.commandbutton1.enabled = true
    userform1.show
end sub

¡¡¡¡5£®²åÈëÒ»¸ö´°Ìåuserform1£¬ÔÚÆäÖвåÈë4¸ö±êÇ©£¬4¸öÎı¾¿ò£¬Ò»¸ö°´Å¥¡£·Ö±ðÉèÖÃËüÃǵÄÏà¹ØÊôÐÔ£¬ÆäÖУ¬¡°ËùÐèÐÐÊý¡±Îı¾¿òµÄ¡°text¡±ÊôÐÔÖµÉèΪ25£¬¡°ËùÐèÁÐÊý¡±Îı¾¿òµÄ¡°text¡±ÊôÐÔÖµÉèΪ20£¬¡°Ðмä¾à¡±Îı¾¿òµÄ¡°text¡±ÊôÐÔÖµÉèΪ0.5£¬¡°Ê×β¿ÕÐи߶ȡ±Îı¾¿òµÄ¡°text¡±ÊôÐÔÖµÉèΪ0.4£¬Èçͼ3Ëùʾ¡£

¡¡¡¡6£®Ë«»÷ÃüÁî°´Å¥commandbutton1£¬Â¼ÈëÒÔÏ´úÂ룺

private sub commandbutton1_click()
    dim n as integer    ¡¯¶¨ÒåÒ»¸ö±äÁ¿ÎªÕûÊýÐÍ
    n = 1
    activedocument.tables.add range:=selection.range, numrows:=val(textbox1.text) * 2 + 1, numcolumns _
    :=val(textbox2.text), defaulttablebehavior:=wdword9tablebehavior, autofitbehavior:=wdautofitfixed
    selection.endkey unit:=wdrow, extend:=true
    selection.cells.borders(wdbordervertical).linestyle = wdlinestylenone
    selection.tables(1).rows.heightrule = wdrowheightexactly
    ¡¯É趨±í¸ñÐиßΪ¹Ì¶¨Öµ
    selection.tables(1).rows.height = centimeterstopoints(val(textbox3.text))
    ¡¯ÉèÖñí¸ñÐиßΪÉèÖÃÖµ£¬×÷ΪÐмä¾à
    selection.tables(1).rows(1).height = centimeterstopoints(val(textbox4.text))
    ¡¯ÉèÖõÚÒ»ÐÐÐиßΪÉèÖÃÖµ
    do while n < val(textbox1.text) + 1
        selection.endkey unit:=wdline
        selection.moveright unit:=wdcharacter, count:=2
        ¡¯½«²åÈëµãÒÆÖÁÏÂÒ»ÐÐ
        selection.tables(1).rows(2 * n).height = selection.tables(1).columns(1).preferredwidth
        ¡¯ÉèÐиߵÈÓÚÁпí
        selection.endkey unit:=wdrow, extend:=true
        selection.endkey unit:=wdline
        selection.moveright unit:=wdcharacter, count:=2
        ¡¯½«²åÈëµãÒÆÖÁÏÂÒ»ÐÐ
        selection.endkey unit:=wdrow, extend:=true
        selection.cells.borders(wdbordervertical).linestyle = wdlinestylenone
        ¡¯È¥³ý´ËÐеÄÄÚ²¿¿òÏߣ¬Ö»Óà±ß¿ò
        n = n + 1
    loop
    selection.tables(1).rows(val(textbox1.text) * 2 + 1).height = centimeterstopoints(val(textbox4.text))
    ¡¯ÉèÖÃÄ©ÐиßΪÉèÖÃÖµ
    selection.endkey unit:=wdrow, extend:=true
    selection.cells.borders(wdbordervertical).linestyle = wdlinestylenone
    selection.tables(1).rows.alignment = wdalignrowcenter
    ¡¯±í¸ñ¾ÓÖÐ
    with selection.tables(1)
        .borders(wdborderleft).linewidth = wdlinewidth150pt
        .borders(wdborderright).linewidth = wdlinewidth150pt
        .borders(wdbordertop).linewidth = wdlinewidth150pt
        .borders(wdborderbottom).linewidth = wdlinewidth150pt
        ¡¯É趨±í¸ñ±ß¿òΪ´ÖÏß
    end with
    selection.endkey unit:=wdline
    unload me¡¡¡¡
end sub

±¾ÎĹ²2Ò³£ºµÚ [1] [2] Ò³ÏÂÒ»Ò³

ÔðÈα༭£ºgzu521

µçÄÔ¿ÎÌ÷ÖÀà
Windows 2000½Ì³Ì
Windows XP½Ì³Ì
Windows 2003½Ì³Ì
Windows Vista½Ì³Ì
LINUX½Ì³Ì
Èí¼þ½Ìѧ
°ì¹«Èí¼þ
Ó²¼þDIY
·ÖÀàÍÆ¼öÐÅÏ¢
¸ü¶à...
´óÀà×îÐÂÎÄÕÂ
¸ü¶à...