[°ÝÃD]¦p¦ó¬O¥Î¥t¥Î¤@Óexcel fileªº¥¨¶°¡A¦Ó¤£»Ýn¶}±Ò¦¹excel file
- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
[°ÝÃD]¦p¦ó¬O¥Î¥t¥Î¤@Óexcel fileªº¥¨¶°¡A¦Ó¤£»Ýn¶}±Ò¦¹excel file
¥»©«³Ì«á¥Ñ jarodz ©ó 2012-1-4 00:17 ½s¿è
¦]¬°¤p§Ì¼g¤F¤@¨Ç VBA ªº¥¨¶°¤À¨Éµ¹¦P¨Æ¨Ï¥Î¡A
¤@¶}©l¬O©ñ¦b¤@Óexcel¡An¥Îªº¤H¥hcopy³oÓexcel file¨Ó¥Î¡A
¦ý¬OÀHµÛ¨Ï¥Î¤H¼Æ¤Î¦¸¼ÆÅܦh¡A¥[¤W¤¤³~¦³§ïª©¡A²{¦bÅܦ¨¦n´XÓÀɮצn´XÓª©¥»¡A
®`§Ú¦Û¤v³£§Ñ¤FþÓ¬O³Ì·sª©¡A¤U¦¸n±qþÓ§ï°_¡C
«á¨Óµo²{¥i¥H§@Ó«ö¶s¥hcall¦P¤@Óexcel¸Ìªº¥¨¶°¡A
¦ý¬O¹J¨ì¤@Ó°ÝÃD¡A¬O¨C¦¸°õ¦æ³£·|§â³oÓ¦@¥Îªºexcel¶}°_¨Ó¡A
¦³¨S¦³¿ìªk¥i¥H¤£Åý¥L¶}°_¨Ó©ÎÁôÂð_¨Ó¥B¤£·|§âÀÉ®×Âꦨ°ßŪ¡C
ÁÂÁ¦^µª¡C
¤@Ó¹ïexcel¾Þ§@¤£¼ôªºµ{¦¡¤H¯d¡C |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
¦^´_ 2# GBKEE
Dear GBKEE,
ÁÂÁ§Aªº¦^µª¡A
¤£¦n·N«ä¡A¥i¯à¬O§Úì¥ýªº·N«ä´yzªº¤£²M·¡¡A
§Ú·Q§@ªº¬OÃþ¦ü¼W¯q¶°¡A(§Ú¤w¸gª¾¹D¦p¦ó§â¤@¯ëxls§Ë¦¨¼W¯q¶°)
¦ý¤£ª¾¦p¦ó¦b·s«Øªºexcel¤¤ call ³oÓ¼W¯q¶°¸ÌªºSub routine?
³Ì²×§Ú¬O§Ë¦¨,ÂIÀ»¦¹excel¼W¯q¶°·|¦Û°Ê¦b¤u¨ã¦C¼W¥[«ö¶s¡A
«ö¦¹«ö¶s´N·|°õ¦æexcel¼W¯q¶°¤¤ªºsub routine.
ÁÂÁ¡C
BR,
Jarod |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
¦^´_ 4# GBKEE
²{¦b¦³Ó°ÝÃD,
¦b¹w³Æ§â§@¦¨¼W¯q¶°«eªºxls§@¤@Ó¤u¨ã¦Cªºbutton¡Aassign ³oÓxls¸Ìªºmacro µ¹¥¦¡A
µM«á¦A§â IsAddin Äݩʳ]¬° true ¡A«áÀx¦s¡C
¦b¥t¥~¤@¥x¶}±Ò¦¹ xls¡A¦¹¼W¥[ªºbuttonµLªk¥X²{¡A
¦n¹³¬OµLªk¬Ý¨ì¼W¯q¶°¸Ìªºsub routine.
³o¦ó¸Ñ?
¦P¼Ëªº°ÝÃD¡Axls³]¬°¼W¯q¶°«á¦bmacro list´N¬Ý¤£¨ì¨ä Macro¡A
¬Ý¤£¨ìÁÙ¬O¥i¥H°õ¦æ¶Ü?
BR,
Jarod
BR,
Jarod |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
Dear GBKEE,
ÁÂÁ¡A·Q¦A½Ð±Ð¤@¤U¥Î Auto_Open ¸ò¼g¦b ThisWorkbook ¥Î Workbook_Open() ¦³¤°»ò®t§O¡A
¦AªÌ°£¤F Auto_Open, Auto_Close ¤§¥~¡A¦b¤@¯ëÁÙ¦³¤°»ò¯S®íªº event ¥i¥H trap ¨ì¡A
³on¥Î¤°»òÃöÁä¦r¬d help ©Î¥hþ¸Ì¥i¥H¬Ý¨ì³o¨Ç event list¡AÁÂÁ¡C
BR,
Jarod |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2011
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-13
- ³Ì«áµn¿ý
- 2014-7-8
|
Dear GBKEE
WorkBook_Open() ¥i¥H«Üª½Ä±ªºµo²{¤F¡A
¦ý¬O Auto_Open()³oÓ¬O¥hþ¸Ì¬d¨ìªº?
§Ú·Q°Ýªº¬O¤@¯ëmodule¥i¥H¥Îªºeventn¥hþ¬d?
Auto_Open() ¦bIDEªºµøµ¡¤¤¤£¹³WorkBook_Open()·|¦Û°Ê¦C¥X¨Ó¡C
BR,
Jarod |
|
|
|
|
|
|