¦Û°Ê¶ñ¤J¥¼°µ¦C¦L¼Ð°Oªº§Ç¸¹
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
¦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
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
  
|
¦^´_ 12# chi830
Âà¦sPDFÀÉ¡A¦b§Ú´X¥x¹q¸£¸Õ³£¥i¥H¡A©Ò¥H§Ú¤]¤£ª¾°ÝÃD¦bþ¡H§Ú¦A¬ã¨s¬Ý¬Ý
¦Ü©óºô¸ôªÚ¾F¡A¨þ¨þ¡I§Ú¨S¥Î¹L©Ò¥H¥u¦n½Ð¨ä¥L¤j¤j¦^µª¤F¡I |
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
¦^´_ 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
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
²{¤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
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
  
|
¦^´_ 15# chi830
¥t¦s·sÀɦ³¦p¤U¹Ï¥i¦s¦¨PDFªº¿ï¶µÀ³¸Ó³£¥i¥H¦s§a¡I
|
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
¦^´_ 16# lpk187
¶â¶â~ªº½T¦p¦¹~¤F¸Ñ¤F...ÁÂÁ±z~~^^ |
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
¦A½Ð±Ð¤@¤U~
BeforePrint¡A³oÓEvent¬O¦b¹wÄý®É´N¤w±NWorksheets("§Ç¸¹").Cells(fi.Row, "B") = "V"ªºÈ¼g¤J
¬O§_¦³¤èªk¥iÅýuser¬O¯u¥¿°e¥X¦C¦L«ü¥O¡A¸Ó¬qµ{¦¡½X¤~¥Í®Ä©O?
¥B¦P®É¦Û°Ê"«·s¨ú¸¹"
For Each §Ç¸¹ In Worksheets("§Ç¸¹").Range("A2:A" & Worksheets("§Ç¸¹").Range("A65535").End(xlUp).Row)
ro = §Ç¸¹.Row
If Sheets("§Ç¸¹").Cells(ro, "B") = "" Then
'[B2] = Worksheets("§Ç¸¹").Cells(ro, "A")
Worksheets("²Îp").Range("B2").Value = Worksheets("§Ç¸¹").Cells(ro, "A")
End
End If
Next |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
  
|
¦^´_ 18# chi830
¤£ª¾¹D¬O¤£¬O¦]¬°ª©¥»¤£¦Pªº¦]¯À¡C§Úªº2010¦b°õ¦æ¹wÄý¦C¦L®É¡A¨Ã¨S¦³§A»¡ªº±¡ªp¡A³£·|n«ö¦C¦L¤~·|ÅýBeforePrint¨Æ¥ó±Ò°Ê¡I |
|
|
|
|
|
|
- ©«¤l
- 105
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 30
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-30
- ³Ì«áµn¿ý
- 2025-2-19
       
|
¦^´_ 19# lpk187
¬Ý¨Ó¯u¬Oª©¥»ªº°ÝÃD¡A§Ú¦b2010ª©´ú¡A¹wÄý®É¨Ã¤£·|¼g¤JÈ
¨º½Ð±Ð¤j¤j¡A¯à¤£¯à¦b¹wÄý¦C¦L®É¡A¨t²Î§PÂ_Worksheets("²Îp").Range("B2")¬O§_¦bWorksheets("§Ç¸¹").Cells(fi.Row, "B") = "V"
¦pªG¬°¤w¼Ð°O¡A«h¸õ¥X°T®§"¸Ó§Ç¸¹¤w¦s¦b¡A½Ð¥ý²M°£¦C¦L¼Ð°O©Î¬O«·s¨ú¸¹"¡AµM«á²×¤î¤£ÅýÄ~Äò¦C¦L |
|
|
|
|
|
|