ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA«áºÝ³B²z

[µo°Ý] VBA«áºÝ³B²z

¦U¦ì«e½ú¦n
¤p§Ì¦Û¾ÇVBA¡BSQL¨â­Ó§«ô(ÁÙ¬O·s¤â¤¤ªº·s¤â...)
¥Ø«e·Q§Q¥ÎVBA·í§@SQLªº«áºÝ¾ã²z,©ó¬O¦Û¤v°µ¤F¨Ç¤p¥\¯à...
1. Â^¨úTitleÄæ¦ì«ö¶s  (¿ï°_©l¦ì¸m©Mµ²§ô¦ì¸m)
2.Â^¨úTitle¤º®e«ö¶s   (¿ï¨ú½d³ò¥²¶·¦PÄæ)
¥D­n¬O§âSQLªº¸ê®Æ§ì¤U¨Ó©ñ¦bSheet2,¦b¨Ï¥Î³o¨Ç¥\¯à§â¸ê®Æ©ñ¦bSheet3¯S©wªºÄæ¦ì,
¥Ñ©ó¤£ª¾¹D¥H«á¤u§@·|¸I¨ì¬Æ»ò¼Ëªº®æ¦¡,©Ò¥H·Q°µ¤@­Ó¥i¥H¿ï¾Üªº°ÊºA¼Ò¦¡,
¦ý¤£ª¾¹D¤p§Ì§Úªº¤è¦V¬O§_¥¿½T,©ó¬O·Q½Ð°Ý¦U¦ì«e½ú­Ì¯à§_µ¹§Ú¨Ç«Øij©ÎªÌ¤è¦V
¤p§Ì·P¿E¤£ºÉ!

P.S. µ{¦¡¥\¤O«Ü®z...ÁٽШ£½Ì

test¾ã¦X.rar (22.79 KB)

As you sow, so shall you reap.

GBKEEª©¥D¤j¤j§A¦n
§Ú­«·s¤W¶Ç¤@­ÓÀÉ®×,¥D­n¬OVBA«áºÝ³B²z,¥u¦³¨â­Ó«ö¶s!
¸ê®Æ®wªº¸ê®Æ§Ú¤w¸g©ñ¦b"SHEET2"¸Ì­±,§Q¥Î§Ú°µªº¨â­Ó«ö¶s¦A§â"SHEET2"ªº¸ê®ÆÂ\©ñ¸m"SHEET3"
¦]¬°§Ú¤~­è±µÄ²¸ê®Æ®w©MVBA...©Ò¥H¸ê®Æ®wªº¸ê®Æ¬O§ÚÀH«K¥´ªº...¥Øªº¥u¬OÅýVBA¦³¸ê®Æ§ì¤U¨Ó°µ«áºÝ³B²z

test1¾ã¦X.rar (18.69 KB)

As you sow, so shall you reap.

TOP

¦^´_ 2# milk30320

ª½±µÅª¨ú¸ê®ÆÀÉ,¨Ó³B²z¤£¬O§ó¦n¶Ü?
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 3# GBKEE
GBKEE¶Wª©¤j¤j§A¦n~
À³¸Ó¬O»¡§Ú§â¸ê®Æ¥ý§ì¨ìexcel©ñ,¦b±N¸ê®Æ½d³ò½Æ»s¶K¤W¦³ÂI¦h¦¹¤@Á|§a...
·PÁÂGBKEEªº´£¿ô...
Ãö©ó³oÂI§Ú¦³µo²{¤F, ¦Û¤v¤]¦³ÂI·Qªk¸Ó«ç»ò°µ«áºÝ
³o´X¤Ñ¤p§Ì¥ý¼g¼g¬Ý...¦³¦¨ªG¦b¥áÀɮפW¨Ó©M¤j®a¤À¨É!
As you sow, so shall you reap.

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD