¦Û°Ê¶ñ¤J¥¼°µ¦C¦L¼Ð°Oªº§Ç¸¹
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¦Û°Ê¶ñ¤J¥¼°µ¦C¦L¼Ð°Oªº§Ç¸¹
½Ð±Ð¦U¦ì¥ý¶i~
¦b¬Y¤@³]p¦nªº¸ê®Æ¶±¡A·QnÅýexcel¦Û°Ê±q ¡u§Ç¸¹¡v¶¤¤¡A±a¤J¥Ø«e©|¥¼¥Î¹Lªº§Ç¸¹È¡A¦³¤°»ò¤èªk¶Ü?
ªþ¤WÀÉ®×»¡©ú~~ÁÂÁ¤j®a~~
¦¨«~¥XªùÃÒ+§Ç¸¹.zip (18.23 KB)
|
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¤Ó´Î¤F~·Plpk187¥ý¶iªº¦^´_¡A ¦³¦¬Àò ~Æg
§ï¥ÎButtonªº¤è¦¡¹ê§@¡Aok~
¦ý²{¦b·Q°µ§ó¶i¤Æªº¥\¯à(¤£±Ä¥Îbutton)
1¡Buser¯uªº¦C¦L«á¡A¦Û°Ê¦^¼g§Ç¸¹¶BÄ檺V¡A³o¸Ìªºµ{¦¡½XÀ³¦p¦óקï?
2¡B¦P®É¦C¦L§¹¡A'²Îp¶'n¥t¦s¦¨ÀɦW¬°'²Îp¶'B2ªºexcel¡A¨Ò¦pNo.20150007.xls
²Îp¶³o¸Ì¬O¼Ï¶s©Ò¶]¥X¨Óªºµ²ªGÈ¡A¥t¦sÀÉ«á¡A©Ò¨D¬Onì¿z¿ïªº¤º®eÈ
¥H¤W~¦A½Ð¥ý¶i̽ç±Ð~ |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¨Ìlpk187©Ò´£¨Ñªºµ{¦¡½X¡Aµy§@eventªº×§ï¡A²{¤w¤jP§¹¦¨©Ò´Á±æªº¥\¯à
¦ý¤£¾å±o¬O§_¯àÅý¥t¦sªº·sÀɦs¬°.jpg or pdfÀÉ©O? ¦Û¤w¸ÕµÛ§ïµ²ªG¬O¤£¦æªº~¨þ
¦¹¥Øªº¡A¬O¤£§Æ±æUser¯à¦Û¦æ¶}±ÒÀÉ®××¥¿~
¥H¤W~ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¦^´_ 8# lpk187
¤´¬OµLªk¦sPDFÀÉ©O~ ¤@¼Ëªº¿ù»~°T®§ |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¸Õ¸Õ¬Ý
²Ä¤GÓ°ÝÃD¦p¤U
Worksheets("²Îp").Select
Range("A110").Select
Selection.Copy
'¤W±ªº¦¡ ...
lpk187 µoªí©ó 2015-3-11 13:46
¸Õ¤F¤@¤U¡A¨S¦³¿z¿ï¤º®e¥X²{~
«á¨Ó§âxlUp§ï¬°xlDown´N¥i¥H¤F
Range("A1:L" & Cells(Rows.Count, "L").End(xlDown).Row).Copy
ÁÂÁÂlpk187¥ý¶iªº´£ÂI~
²{¦b´N®tÂà¦sPDFªº°ÝÃD¤F..... |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¦A½Ð±Ð¦sÀɪº¸ô®|¥i¥H¬OºôªÚ¤¤ªº¥ô¤@¥x¹q¸£
Patha = "\\BUS\SCAN\¥XªùÃÒ\" '¦sÀɸô®|³o¼Ë¬O¥i¥H¦¨¥\ªº
¦ýY¦³±b¸¹/±K½X®É¡An«ç³Â¦b»yªk¤¤¥ý±N¸ê°T¿é¤J©O?? |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¦^´_ 13# lpk187
§Ú²×©óª¾¹D§Ú¿ù¦bþ¸Ì¤F¡A¦]¬°¤§«eÂà¦s*.xlsb®É¡A¬O¦b¹wÄý¦C¦Lªº®ÉÔ´N·|¥Í¦¨ÀɮסA¦P®É¤]¬O³QBeforePrint³oÓeventµ¹»X½ª¤F¡A
©Ò¥H§Ú¤@ª½¥H¬°¹wÄý«á´NÀ³¸Ó²£¥Í·sÀÉ¡A¤S¦]¬°¦b´ú¸Õ¡A©Ò¥H¤@ª½¨S¯uªº«ö¦C¦L¡A¤~·|¤@ª½¤£²£¥ÍPDF
²{¦bOK¤F~~~¯u¬O·PÁÂlpk¤j¤j¹Æ....^__^
±µ¤U¨Ó¡Aºô¸ôºÏºÐ¾÷ªº±b/±K¡An½Ð¨ä¥L¥ý¶iÀ°À°¦£¹Æ......·PÁÂ~~~ |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
²{¤Sµo²{¤@Ó°ÝÃD¡A½Ð°ÝÂàPDF¤@©wn¹q¸£¦³¦w¸ËAdobe Acrobat ¶Ü??
¦]¦³ªºUser¸Ëªº¬O§K¶OÂàPDFªºµ{¦¡(¨Ò¦p:CutePDF OR PrimePdF)¡A¥Î³oÓ³nÅ骺¤H¾Þ§@·|µLªkÂà¦sPDFC.... |
|
|
|
|
|
|
- ©«¤l
- 104
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 87
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2024-5-10
|
¦^´_ 16# lpk187
¶â¶â~ªº½T¦p¦¹~¤F¸Ñ¤F...ÁÂÁ±z~~^^ |
|
|
|
|
|
|