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

¬°¤°»òµ{¦¡¶]¨ì¤@¥b³£·|°±¦í¤£Ä~Äò¤F?

¬°¤°»òµ{¦¡¶]¨ì¤@¥b³£·|°±¦í¤£Ä~Äò¤F?

³Ìªñ§Q¥Î¤@­Óexcel¬¡­¶Ã¯¥h¾Þ§@¨ä¥L­Ó¬¡­¶Ã¯

¬yµ{¬O³o¼Ë:

¶}±Ò¬¡­¶Ã¯(¥D­nªºµ{¦¡) --> ÂÇ¥ÑVBA¥h¶}±Ò¥t¥~¤@­Ó¬¡­¶Ã¯(¦¸­nªº)  --> ¦b¦¸­nªº¬¡­¶Ã¯¤W¶i¦æ¤u§@  --> ¤u§@µ²§ô«á¦A¸õ¦^¥D­nªº¬¡­¶Ã¯,¨Ã±N¦¸­nªº¬¡­¶Ã¯¦sÀÉÃö³¬

µ{¦¡¦³®É­Ô·|¶]¨ì¤@¥b´N°±¦í¤F,±q¥D¬¡­¶Ã¯¸õ¨ì¦¸¬¡­¶Ã¯´N¬ðµM°±¦í¤£Ä~Äò¤u§@¤F,±q·s°õ¦æ«á¤S¦^´_¥¿±`,ÁöµM¤£¬O±`µo¥Í,¦ý·Q½Ð°Ý¤j®a³o¬O¤°»ò­ì¦]©O?

ÁÂÁÂ

¦^´_ 1# sasho

¦Cµ{¦¡½Xµ¹¤j¹Ù¬ã¨s¬Ý¬Ý..

TOP

¥»©«³Ì«á¥Ñ sasho ©ó 2010-7-31 00:43 ½s¿è

Workbooks.Open Filename:="C:\DATA\" & date & ".xls"
Workbooks(code & ".xls").Activate

¦b¥D­nªº¬¡­¶Ã¯(book1.xls)°õ¦æ¤W¤èªºµ{¦¡½X
¤W­±¨â¦æ¬O§Ú±q­ì¥»ªº¬¡­¶Ã¯(book1.xls)¸õ¨ì±Mªù¦bÀx¦s¸ê®Æªº¬¡­¶Ã¯(code,xls)©Ò¤Uªº«ü¥O
«á­±±µÄòªº¬O¤@¨Ç³B²zªºµ{§Ç
µ{¦¡±`±`·|¶]¨ì³oÃä´N°±¦í¤£·|©¹¤U¶]¤F,,¥i¥H½Ð°Ý¬O¤°»ò­ì¦]³y¦¨ªº¶Ü?
·PÁÂ

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-31 08:46 ½s¿è

¦^´_ 3# sasho

      ¸Õ¸Õ¦bcode.xls ªºA1¤J                     =SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")
´N·|¦³code.xls ªºLINK   
eg.  C:\code.xls
   
    Workbooks.Open Filename:="C:\code.xls"
MyCodeName= ActiveWorkbook.Name
Workbooks(MyCodeName).Activate
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# sasho


    Workbooks.Open Filename:="C:\DATA\" & date & ".xls"
Workbooks(code & ".xls").Activate

ÀɦW¬O ¤é´Á+".xls" ÁÙ¬O code +".xls"

¦ô­p§A­nªº¬O
  1. Workbooks.Open Filename:="C:\DATA\" & code & ".xls"
  2. Workbooks(code & ".xls").Activate
½Æ»s¥N½X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¤£¦n·N«ä ¥´¿ù¤F

À³¸Ó¬O:
Workbooks.Open Filename:="C:\DATA\" & code & ".xls"
Workbooks(code & ".xls").Activate

¨ä¤¤code¬OÅܼÆ,¾ã­Óµ{¦¡°õ¦æ¨Ã¤£·|¦³°ÝÃD,¦]¬°¾ã­Ó¶]¤U¨Ó¨Ã¨S¦³¿ù»~µo¥Í
¥u¬O¦³®É­Ôµ{¦¡°õ¦æ«á§Ú´N§âexcel¥á¦b®ÇÃäÅý¥L¦Û¤v¶],
µM«á¥h²áMSN
¦ý¦³¥i¯à²á¤@²á´Nµo²{µ{¦¡°±¦í¤F¨S¦³Ä~Äò¶]
¦pªG¬Oµ{¦¡°õ¦æ«á´N¨S¦³°µ¨ä¥L¨Æ±¡ªº¸Ü¨º´N¤£·|µo¥Í¥H¤Wªº°ÝÃD
©Ò¥H·Q»¡,¬O¤£¬O§Q¥ÎVBA°µ¦h­Ó¬¡­¶Ã¯±±¨îªº®É­Ô,·|¦³³o¼Ëªº¤pbug²£¥Í?

TOP

¦^´_ 6# sasho


³o­Ó¦³«Ü¦h¥i¯à©Ê... §A½T©w¬O³o¥y¥X°ÝÃD¶Ü? ¥i§_µo¤@¤U§¹¾ã¥N½X?
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 6# sasho


Workbooks.Open Filename:="C:\DATA\" & code & ".xls"
Workbooks(code & ".xls").Activate
­ì«h¤WWorkbooks(code & ".xls").Activate³o¥y¬O¦h¾lªº
°õ¦æWorkbooks.Open Filename:="C:\DATA\" & code & ".xls"
§@¥Î¤¤¬¡­¶Ã¯´N¬OWorkbooks(code & ".xls")
§Aµ{¦¡¤£¶]­n¥Î³v¦æ¨Ó°»¿ù

°£«D¬OWorkbooks(code & ".xls").ªºÀɮ׫ܤj©Î¦³¨ä¥L¶}±Ò°ÝÃD
§_«h³o2¦æ¬O§ä¤£¨ì°ÝÃDªº
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¦U¦ì«e½úªº¸Ñµª..

¤£¹L§Ú·Q¤j®a¥i¯à»~·|§Úªº·N«ä¤F,§Ú¦A»¡©ú¤@¤U¦n¤F

§Ú¥Ø«e§Q¥Î¤@­Óexcel·í§@¥Dµ{¦¡¥h±±¨î¨ä¥L(700¦h­Ó)excel¤u§@ï

±N©Ò¦³ªºµ{¦¡½X³q³q¼g¦b¥Dµ{¦¡·í¤¤,¨ä¥Lªº¬¡­¶Ã¯´N¥u¬O·í§@¸ê®Æ®w§@Àx¦s¦Ó¤w

³o­Óµ{¦¡¶]°_¨Óªº®É­Ô,¦pªG¨S¦³¥h¨Ï¥ÎMSNªº¸Ü,¬O¨S¦³°ÝÃDªº

°ÝÃD¬O,·í§Ú§âµ{¦¡¶}±Ò«á,¥á¦b®ÇÃä°õ¦æ¦Óµøµ¡«h©Ô¨ìMSN²á¤Ñªº¸Ü

¨ºµ{¦¡´N·|¶]¨ì¤@¥b´N°±¦í(°±¦í¦Ó¤w,¨Ã¨S¦³¥X²{¿ù»~°T®§)

¦Ó°±¦íªº¦a¤è´N¬O¦bÃö³¬¤W¤@­Ó·í§@¸ê®Æ®wªº¬¡­¶Ã¯,¶}±Ò·sªº¸ê®Æ®w¬¡­¶Ã¯¤§«á

¶}±Ò¤§«á´N°±¦í¤F,¥»¨ÓÀ³¸Ó·|¦³«áÄòªº¾Þ§@,¦ý¦b³oºØ±¡ªp®É,µ{¦¡´N¤£·|Ä~Äò¶]¤F

©Ò¥H§Ú·Q,À³¸Ó¤£¬O¦Û¤v¼gªºµ{¦¡½X¦³¤°»ò°ÝÃD(¦]¬°¦pªG¤£¨Ï¥ÎMSN¥i¥H«Ü¶¶§Q¶]§¹)

¥i¥H½Ð±Ð¤j®a¬O¤°»ò­ì¦]¶Ü?

ÁÂÁÂ

P.s Á`¦@¦³±Nªñ700MªºÀÉ®×,©Ò¥H¤£¤è«K¤W¶Ç,sorry

TOP

´N¦phsieh¤j©Ò»¡,
§A¥i¥H¥ý¸Õ¸Õ¥Î°»¿ù¼Ò¦¡¨Ó¶],
µo²{µ{¦¡°±¤F, ¥i¥H«öctrl+break§âµ{¦¡°±¤@¤U, ¬Ý¬Ý°±¦b¨º¸Ì.

§A¤]¥i¥H¥uµo¤@¤U¥N½X¤W¨Ó¬Ý¬Ýªº~
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD