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

VB ³]©wªí³æ¿é¤J¦WºÙ«á¥´¶}¸ê®Æ§¨°ÝÃD¡C

VB ³]©wªí³æ¿é¤J¦WºÙ«á¥´¶}¸ê®Æ§¨°ÝÃD¡C

§Ú·Q§Ë¤@­Óªí³æ,Åý§Ú¿é¤J¤@­Ó¦WºÙ¤§«á«ö½T©w,¥L·|¥´¶}§Ú©Ò¿é¤J¦WºÙªº¸ê®Æ§¨¥X¨Ó,½Ð°Ý³o­Óªì¨B¤]¬O­n¦p¦ó¥h°µ,¬O¤£¬O¥ý§â¦WºÙ©w¸q¬°¸ê®Æ§¨¥Ø¼Ð¦ì¸m,·í§Ú¦bªí³æ¤º¿é¤J¸Ó¦WºÙ«á,¥L·|¦Û°Ê¥´¶}¬ÛÃöªº¸ê®Æ,½Ð°Ýªì¨BÀ³¸Ó¬O¦p¦ó¥h¾Þ§@,ÁÂÁ¤F :Q

¦^´_ 1# stephenlee

¶}±ÒExcel¤èªk¡AÃþ¦ü½d¨Ò°Ñ¦Ò
  1. Dim WB, XL, oSheet As Object
  2. XL = CreateObject("Excel.Application")
  3. XL.Visible = True
  4. WB = XL.Workbooks.Open("\\¸ô®|\¤u§@ªí.xlsx")
  5. oSheet = XL.Workbooks("¤u§@ªí.xlsx").Sheets("¤u§@ªí1")
½Æ»s¥N½X
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD