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

(µo°Ý)½Ð°ÝVBA¦p¦ó¤Á´«µøµ¡

(µo°Ý)½Ð°ÝVBA¦p¦ó¤Á´«µøµ¡

¦U¦ì¥ý¶i¡A½Ð°Ý¦p¦ó¥ÑExcelÂÇ¥ÑVBA¡A¤Á´«¦Ü¤W¤@­Óµøµ¡¡C

   SendKeys "%{tab}", True

¤p§Ì¬Ý®Ñ¥H¤Î¬dºô¸ô¸ê®Æ±o¥X¥Î¥H¤Wªº¤è¦¡¡A¥i¬O«o¨S¦³§@¥Î¡C
½Ð°Ý¿ù¦b­þ¸Ì¡A·Ð½Ð«ü¾É¡AÁÂÁÂ~~

P.S.¤p§Ì¬O¥ÎWindows 7¡]64¦ì¤¸¡^¥H¤Îoffice 2003¡]32¦ì¤¸¡^
Hi~

¦^´_ 1# jewayy
§Aªº TAB ­n¥´­^¤å¤j¼g:

SendKeys "%{TAB}", True

¸õ¦^¤W¤@­Óµøµ¡.zip (7.13 KB)

TOP

¦^´_ 1# jewayy
¤Á´«®à­±µ{¦¡µøµ¡     ALT+TAB      -> SendKeys "%{TAB}", True   
¤Á´«µ{¦¡¤¤ªºµøµ¡     CTRL +TAB   ->SendKeys "^{TAB}", True

TOP

ALT+TAB      ¬Oxpªº§Ö³tÁä
win7¤]³\·|»Pxp¤£¦P
§AÀ³¸Ó¥ý½T©w§Ö³tÁä¬O§_¦³®Ä¦A¥ÎSendKeys½Õ¥Î¡C

TOP

ÁÂÁ¨â¦ìªº«üÂI¡C
¤£¹L§ó§ï¬°¤j¼g«áÁÙ¬O¤@¼Ë¨S¦³§@¥Î¡C

·|¤£·|¸ò64¦ì¤¸ªºÀô¹Ò¦³Ãö¡A¦]¬°¦³·j´M¤@¤UYahooª¾ÃÑ¡A¦n¹³¦³¤H´£¨ì:
""Vista¤¤ VBA sendkeys µLªk¦b¨ä¥¦µ{¦¡¤W¨Ï¥Î - Yahoo!©_¼¯ª¾ÃÑ+""
¤£¹L¦^ÂЬݤ£À´¡A¤~¨Ó³o¸Ì¸ß°Ý¡A«¢«¢~½Ð¦hÀ°¦£~~
Hi~

TOP

¦^´_ 5# jewayy
ªþ¤WÀɮ׬ݬÝ

TOP

¨ä¹êÀɮפ]¨S¦³¤°»ò¡A´N¬O²³æªº¥[¤Wsendkeysªº«ü¥O¦Ó¤w
SendKeys "^{TAB}", True
¦ý¬O´N¬O¨S¿ìªk¹B§@¡A¦Ó¥B·|¥¢¥hµJÂI¡A³sÀx¦s®æªº®Ø®Ø³£¤£¨£¤F~~«¢«¢
¤£¹L
SendKeys "^{TAB}", True
«o¥i¥H¦³§@¥Î¡A¯u©_©Ç.......


P.S. Windows 7¸ÌªºAlt+Tab»PXP¤@¼Ë¡A³£¬O¤Á´«µøµ¡¥Îªº¡A©Ò¥H¥Î¹êÅéÁä½L¥i¥H¤Á´«¡A¥ÎVBA¼g¨S¿ìªk¤Á´«¡A³o¤~¬O©Ç°Ú~

¦pªþ¥ó¡A½Ð¬d·Ó~~
Desktop.rar (113.38 KB)
Hi~

TOP

¦^´_ 7# jewayy
¦]¬°§Úªº¨t²Î¤£¬O Windows 7 ©Ò¥H¤£¯à´ú¸Õµ²ªG,
¤£¹L§Ú¤§«e¹J¹L°õ¦æµ{¦¡ªºÅv­­¤£°÷®É¬Y¨Ç¥\¯à·|¤£¯à°Ê§@,
©ÎªÌ§A¥i¥H¸Õ¸Õ¬Ý,
¶}±Ò§Úªº¹q¸£ ©Î ÀÉ®×Á`ºÞ ¹ïµÛ Book2.xls «ö·Æ¹«¥kÁä,
¦A¿ï¾Ü "¥H¨t²ÎºÞ²z­û¨­¤À°õ¦æ" ¸Õ¸Õ.

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD