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

[µo°Ý] ¨Ï®à­±ªºµe­±(¦p¨ä¥LÁ`ºÞ¸ê®Æ§¨)ÁY¤p(¦p¦P«ö"-")

[µo°Ý] ¨Ï®à­±ªºµe­±(¦p¨ä¥LÁ`ºÞ¸ê®Æ§¨)ÁY¤p(¦p¦P«ö"-")

½Ð±Ð½Ñ¦ì¤j¤j
·í§Úworkbook_open®É
·QÅý®à­±ªºµe­±(¦p¨ä¥LÁ`ºÞ¸ê®Æ§¨)¦Û°ÊÁY¤p¦Ü³Ì¤U¦C(¦p¦P«ö"-")
¤£ª¾BVA ªº»yªkÀ³¦p¦ó?

¤£¬O¿ý»s¤@¤U´N¦³¤F¡C

TOP

¦^´_ 2# kim223824

µLªk¿ý»s¨ä¥Lwindows®à­±ªºµøµ¡(¦p¨ä¥LÁ`ºÞ¸ê®Æ§¨)¦Û°ÊÁY¤p

TOP

¦^´_ 3# yangjie
¬O³o¼Ë¶Ü?
  1. Option Explicit
  2. Sub Ex()
  3.     With Workbooks.Open("D:\TEST.XLS")
  4.         Application.WindowState = xlMaximized
  5.         '*****
  6.         '*****
  7.         '*****
  8.     End With
  9. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD