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

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j¦p¦óÁôÂì¡­¶Ã¯??

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j¦p¦óÁôÂì¡­¶Ã¯??

°²¦p§Ú¦³¨â­ÓexcelÀÉ®×
²Ä¤@­Ó¥s   AAA.xlsx
²Ä¤G­Ó¥s   BBB.xlsx

·í§Ú§Q¥ÎAAA¶}±ÒBBB®É...­n¦p¦ó¤£¦b§@·~¨t²Î¤WÅã¥ÜBBBªº¬¡­¶Ã¯??
§Ú¸ÕµÛ§Q¥Î¦¹¬q Application.Visible = False
¥¦·|§â¨â­Ó¤u§@ªí³£ÁôÂð_¨Ó¡A
½Ð°Ý¦U¦ì¤j®v­n¦p¦óÁôÂëü©wªº¬¡­¶Ã¯´N¦n???

¦^´_ 1# ´Ñ»y³¾»ï

workbooks.open "D:\BBB.xlsx"
windows("BBB.xlsx").visible=false
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


  ³o­Ó§Ú­è­è¦³´ú¸Õ¨ì¡A¤£¹LÁÙ¬O·|¸õ¥X¨Ó¤@¤U¤l¤~ÁôÂÃ(Åý§Ú¥H¬°¨SÁôÂÃ)¡A
½Ð°Ý¯àÅý¥¦ª½±µ¦b¶}±Ò®É¥ß§YÁôÂöÜ??

TOP

¦^´_ 3# ´Ñ»y³¾»ï
Application.ScreenUpdating = False
workbooks.open "D:\BBB.xlsx"
windows("BBB.xlsx").visible=false
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    Ãö³¬¿Ã¹õ¸õ°ÊÅã¥Ü¨º­Ó§Ú¦³¥Î¤F...
¤£ª¾¬O¤£¬O§Ú¦³´X¬q¥¨¶°¦³¥h«ü©w¨ìbbbªº¤u§@ªí...
©Ò¥H¥L¤~¤S¸õ¥X¨Ó...??

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-4-29 14:18 ½s¿è

¦^´_ 3# ´Ñ»y³¾»ï
¶}±Ò®É¥ß§YÁôÂÃ
CreateObject ("BBB.xlsx")  ©Î   GetObject("BBB.xlsx")

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD