µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ½Ð°ÝHsiehª©¥D HPageBreaks(1).Location HpageBreak() ¤¤ªº¤Þ¼Æ 1 ªº·N¸q¬°¦ó?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
½Ð°ÝHsiehª©¥D HPageBreaks(1).Location HpageBreak() ¤¤ªº¤Þ¼Æ 1 ªº·N¸q¬°¦ó?
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
115
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4071 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-5-19
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
115
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-5-19
1
#
¸õÂà¨ì
»
µoªí©ó 2011-1-1 11:42
|
Åã¥Ü¥þ³¡©«¤l
²Ä¤@±ø¤À¶½u
½Ð°Ñ¾\VBA»¡©ú¡A¦¹³Bªº1´N¬OitemªºÈ
HPageBreaks ª«¥ó¦¨û
¦C¦L½d³ò¤º©Ò¦³¤ô¥¤À¶²Å¸¹ªº¶°¦X¡C
¤èªk
¦WºÙ ´yz
Add ·|·s¼W¤ô¥¤À¶²Å¸¹¡C
ÄÝ©Ê
¦WºÙ ´yz
Application ¦b¤£·f°tª«¥óÃѧO²Å¸¹¨Ï¥Îªº±¡ªp¤U¡A³oÓÄÝ©Ê·|¶Ç¦^¥Nªí Microsoft Excel À³¥Îµ{¦¡ªº Application ª«¥ó¡C·í·f°tª«¥óÃѧO²Å¸¹¨Ï¥Î®É¡A³oÓÄÝ©Ê·|¶Ç¦^ Application ª«¥ó¡A¥Nªí©Ò«ü©wª«¥óªº«Ø¥ßªÌ (³oÓÄÝ©Ê¥i¥H·f°t OLE Automation ª«¥ó¤@°_¨Ï¥Î¡A¨Ó¶Ç¦^¸Óª«¥óªºÀ³¥Îµ{¦¡)¡C°ßŪªº¡C
Count ·|¶Ç¦^¥Nªí¶°¦X¤¤ª«¥ó¼Æªº Long È¡C
Creator ·|¶Ç¦^ 32 ¦ì¤¸¾ã¼Æ¡A«ü¥X¥Î¥H«Ø¥ß³oÓª«¥óªºÀ³¥Îµ{¦¡¡C°ßŪªº Long¡C
Item ¶Ç¦^¶°¦X¤¤ªº³æ¤@ª«¥ó¡C
Parent ·|¶Ç¦^©Ò«ü©wª«¥óªº¤÷ª«¥ó¡C°ßŪªº¡C
¨ä¤¤ count¬O¤À¶½u¼Æ¶q
item¬O«ü©w²Ä´X±ø¤À¶½u
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
Hsieh
µoµu®ø®§
¥[¬°¦n¤Í
Hsieh
·í«eÂ÷½u
UID
3
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ª÷¿ú
4916
ÂI¦W
115
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
¦b½u®É¶¡
4071 ¤p®É
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-5-19
¶W¯Åª©¥D
©«¤l
4901
¥DÃD
44
ºëµØ
24
¿n¤À
4916
ÂI¦W
115
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 20xx
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥x¥_
µù¥U®É¶¡
2010-4-30
³Ì«áµn¿ý
2024-5-19
2
#
µoªí©ó 2011-1-1 23:28
|
Åã¥Ü¥þ³¡©«¤l
¦^´_
3#
linshin1999
©Î³\§A³o¼Ë«ä¦Ò·|¦n¤@ÂI
¤À¶½u¬O«ü§An¤À¶¦C¦Lªº¶»P¶¤§¶¡ªº¤À¹j²Å¸¹
·íEXCEL¦Û°Ê¤À¶®É¡A·|¥H§A¤WÃä¬É»P¤UÃä¬É¤§¶¡©Ò¯à®e¯Çªº¦C¼Æ§@¬°¹w³]¤À¶
©Ò¥H¡A·í§Aªº¤º®e¤£¶W¹L³oÓ½d³ò®É(¤@¶«K¯à®e¯Ç©Ò¦³¤º®e)
¨º»ò¨Ã¤£·|¦³¤À¶½uªº²£¥Í¡A©Ò¥HcountÄÝ©ÊȬ°0¡A¦ýÁ`¶¼Æ¬O1
Y¬O§An¤â°Ê¥[¤J¤À¶½u(쥻¤@¶ªº¤º®e¤À¦¨2¶)
¨º»ò¥i¨Ï¥ÎADD¤èªk¥[¤J¤À¶½u
¥[¤J«á´N·|¦³¤@±ø¤À¶½u
countÄÝ©ÊȬ°1¡A¦ýÁ`¶¼Æ¬O2
Yn¨ú±o³o¤@±ø¤À¶½u¡A´N¥i¨Ï¥Î´ÁitemÄÝ©Ê
HPageBreaks(1)ªº¥Nªí·N¸q¸ò HPageBreaks.item(1)¬O¤@¼Ëªº
¦ÓLocationÄÝ©Ê¥Nªí¬O¤À¶½u©Ò¦b¦ì¸m¡A¨Ã¤£¬O«ü¤À¶½u¥»¨
HPageBreaks(1).Location ³o¥yªº¸ÑÄÀ´N¬O
²Ä¤@±ø¤ô¥¤À¶½u©Ò¦bªºÀx¦s®æ¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý
TOP
ÀR«ä¦Û¦b :
¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
PHP+MySQL ¤Jªù¹ê§@
ASP »P ASP.NET
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
PowerPoint
Excel£¸¯ë°Ï
¶i¶¥À³¥Î±M°Ï
ºÞ²z¤½§i
JavaScript
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¯»µ·