(µo°Ý)½Ð°ÝVBA¦p¦ó¤Á´«µøµ¡
- ©«¤l
- 36
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 51
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-10-30
- ³Ì«áµn¿ý
- 2015-1-31
|
(µ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~
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
ALT+TAB ¬Oxpªº§Ö³tÁä
win7¤]³\·|»Pxp¤£¦P
§AÀ³¸Ó¥ý½T©w§Ö³tÁä¬O§_¦³®Ä¦A¥ÎSendKeys½Õ¥Î¡C |
|
|
|
|
|
|
- ©«¤l
- 36
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 51
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-10-30
- ³Ì«áµn¿ý
- 2015-1-31
|
ÁÂÁ¨â¦ìªº«üÂ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~
|
|
|
|
|
- ©«¤l
- 36
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 51
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-10-30
- ³Ì«áµn¿ý
- 2015-1-31
|
¨ä¹êÀɮפ]¨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~
|
|
|
|
|
- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 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û¨¤À°õ¦æ" ¸Õ¸Õ. |
|
|
|
|
|
|