µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Word
» word ¥¨¶° ³Q³sÄòIJµo
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
word ¥¨¶° ³Q³sÄòIJµo
eigen
µoµu®ø®§
¥[¬°¦n¤Í
eigen
·í«eÂ÷½u
UID
15495
©«¤l
79
¥DÃD
33
ºëµØ
0
¿n¤À
123
ª÷¿ú
123
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
x64
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
16 ¤p®É
µù¥U®É¶¡
2013-10-24
³Ì«áµn¿ý
2024-3-28
¤¤¾Ç¥Í
©«¤l
79
¥DÃD
33
ºëµØ
0
¿n¤À
123
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
x64
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2013-10-24
³Ì«áµn¿ý
2024-3-28
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2018-5-30 15:56
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
word ¥¨¶° ³Q³sÄòIJµo
word ¥¨¶° ³Q³sÄòIJµo
§Ú°Ñ¦Ò·L³n http://msdn.microsoft.com/en-us/library/office/aa211873(v=office.11).aspx
©M
http://msdn.microsoft.com/en-us/library/office/aa211915(v=office.11).aspx
https://stackoverflow.com/questions/8693798/documentbeforeclose-syntax
°µ¥X¤F word 2003 beforeprint ªº¥¨¶°
·í§Ú¦C¦L®É¡A·|¥ýIJµo³oÓ BeforePrint ³oÓ¥¨¶°
¥Ø«eµo¥Í¤@Ó°ÝÃD¡A§Úµo²{·í§Ú¶}±Ò A¡BB ¨âÓ¦PÃþ«¬doc¡A³£¦³ BeforePrint ¥¨¶°
·í§Ú¹ï A.doc°õ¦æ print ¡ABeforePrint ¥¨¶°´N·|³QIJµo 2¦¸
¦pªG§Ú¶}±Ò¤TÓ A¡BB¡BC ¤TÓ¡A³£¦³ BeforePrint ¥¨¶°ªº DOC
·í§Ú¹ï A.doc°õ¦æ print ¡ABeforePrint ¥¨¶°´N·|³QIJµo 3¦¸¡C
¤£³Ó©_ÂZ¡A¦³¤H¬ÝªºÀ´³o¥¨¶°¨s³º¦³¤°»ò°ÝÃD¡H
ªþ¥ó¦³»ù³æ.DOT ¡A°õ¦æ¨â¦¸´N·|·s¼W¨âÓDOC ¡A°õ¦æ¦C¦L´N·|µo¥Í¤Wzªº°ÝÃD
§Ú¥u·Q°w¹ï§Ún¦C¦LªºÀÉ®×
»ù³æ.zip
(10.15 KB)
¤U¸ü¦¸¼Æ: 2
2018-5-30 15:56
¼Ó¥D¼ö©«
½Ð±Ð¡A¦p¦óÁôÂÃÀx¦s®æ¤ºªº¹Ï¤ù¡H¦p¦ó§Ö³t«ü
EXCEL ¦X¨Ö¦C¦L¤G¡B½d¨Ò¡BµØ«n»È¦æ¦s´Ú¾Ì±ø
½Ð°ª¤â«üÂI¤@¤U¡A¦p¦ó°µ¥X°ÊºAªº¦æ¨Æ¾ä¤ÎÂù
EXCEL ¦X¨Ö¦C¦L ®MªO¦C¦L¶i¶¥±Ð¾Ç step by
2020 ·R§A·R§A ·s¬K¦L¬KÁp
¦p¦óÁקKÀx¦s®æ¤½¦¡¡A¦]¡y°Å¤U¡z¡y¶K¤W¡z¦Ó
½Ð±Ð¾Þ§@ excel vba ª½®Ñ¾î®Ñ¾Þ§@
excel vba ¦p¦ó±N¨ä¥¦µ{¦¡ªºµøµ¡²¾¨ì³Ì¤W¼h
¦p¦ó¨ú±o¬YÓÀɮתºÀx¦s®æ¸ê®Æ¡H¡]ÀÉ®×ÀɦW
dropbox excel vba µ´¹ï¸ô®| §ï ¬Û¹ï¸ô®|
¦¬ÂÃ
¤À¨É
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^
linyancheng
µoµu®ø®§
¥[¬°¦n¤Í
linyancheng
·í«eÂ÷½u
UID
14470
©«¤l
228
¥DÃD
73
ºëµØ
2
¿n¤À
333
ª÷¿ú
333
ÂI¦W
0
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2000, 2019
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¹ü¤Æ¿¤
¦b½u®É¶¡
94 ¤p®É
µù¥U®É¶¡
2013-7-18
³Ì«áµn¿ý
2024-10-13
ª©¥D
©«¤l
228
¥DÃD
73
ºëµØ
2
¿n¤À
333
ÂI¦W
0
§@·~¨t²Î
Windows 10
³nÅ骩¥»
Office 2000, 2019
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¹ü¤Æ¿¤
µù¥U®É¶¡
2013-7-18
³Ì«áµn¿ý
2024-10-13
3
#
µoªí©ó 2018-6-9 22:11
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ linyancheng ©ó 2018-6-9 23:06 ½s¿è
¦^´_
2#
eigen
Document_Open¦bdotÀɨS¦³§@¥Î¡A«O¯dDocument_New§Y¥i¡C
¦bThisDocument¼Ò²Õ¬°Private Sub¼Ò²Õ¡A
¨âÓÀɮפU¡ADim X¦U¦Û¦s¦b¡A
¬G·|²£¥Í¨âÓª«¥óÃþ§O¼Ò²Õªºª«¥ó¡u¼v¤l¡v¡A
¤TÓÀÉ®×´N·|²£¥Í¤TÓ¡A
¤]´N¦P®É¤Þ°_´XÓIJµo¨Æ¥ó¡C
¤@¯ë¼Ò²Õ¤U¬°Public Sub¼Ò²Õ¡A
¤£ºÞ¶}´XÓÀɮסADim X¥u¦³¤@Ó¡A
¥uSet¤@¦¸¡A
¤]¥u²£¥Í¤@Óª«¥ó¡u¼v¤l¡v¡A
IJµo¨Æ¥ó¤]¥u¦³¤@¦¸¡C
¡u¼v¤l¡vªº¡u¹êÅé¡v¬OWord.Application¡A
¥ô¦ó·s¶}ªºÀɮ׳£·|¨ü¼vÅT¡A¤£¥u¥H¥¦¬°½d¥»ªºÀɮסC
TOP
eigen
µoµu®ø®§
¥[¬°¦n¤Í
eigen
·í«eÂ÷½u
UID
15495
©«¤l
79
¥DÃD
33
ºëµØ
0
¿n¤À
123
ª÷¿ú
123
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
x64
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
16 ¤p®É
µù¥U®É¶¡
2013-10-24
³Ì«áµn¿ý
2024-3-28
¤¤¾Ç¥Í
©«¤l
79
¥DÃD
33
ºëµØ
0
¿n¤À
123
ÂI¦W
0
§@·~¨t²Î
win7
³nÅ骩¥»
x64
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2013-10-24
³Ì«áµn¿ý
2024-3-28
2
#
µoªí©ó 2018-5-31 17:08
|
¥u¬Ý¸Ó§@ªÌ
¸Ñ¡G
«ØÓ·sªº module
±N
Dim X As New EventClassModule
Sub Register_Event_Handler()
Set X.appWord = Word.Application
End Sub
²¾¹L¥h¡A¤£n©ñ¦b ThisDocument
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^
TOP
ÀR«ä¦Û¦b :
¡i¦æµ½n¤Î®É¡j¦æµ½n¤Î®É¡A¥\¼wn«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£n°±º¶¤õÔ¡A§_«h«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·