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

¤G­Ó¥¨¶°µ{¦¡°ÝÃD

¤G­Ó¥¨¶°µ{¦¡°ÝÃD

1.½Ð°Ý§Úªº¥¨¶°µ{¦¡¤¤¦³«Ü¦h­ÓCommandButton (1   2    3)¡A¨C­ÓCommandButton¤U­±³£¦³­Ó§O¥¨¶°µ{¦¡
²{¦b§Ú­n°µ¤@­ÓCommandButton4 °õ¦æ«á¥i¥H¨Ì§Ç°õ¦æCommandButton1¡÷CommandButton2¡÷CommandButton3¥¨¶°µ{¦¡¡H
(¦b¤£¨Ï¥Î¨ì¼Ò²Õªº±¡ªp¤U)
2.¦p¦ó³]­p¥¨¶°µ{¦¡¨Ó¦Û°Ê±Ò°Êexcel ¼Ï¯Ã¤ÀªRªí¤¤"§ó·s¸ê®Æ"ªº¥\¯à
¥H¤W½Ð¦U¦ì¥ý¶i¨ó§U~~ÁÂÁÂ

1.½Ð°Ý§Úªº¥¨¶°µ{¦¡¤¤¦³«Ü¦h­ÓCommandButton (1   2    3)¡A¨C­ÓCommandButton¤U­±³£¦³­Ó§O¥¨¶°µ{¦¡¡A²{¦b§Ú­n°µ¤@­ÓCommandButton4 °õ¦æ«á¥i¥H¨Ì§Ç°õ¦æcommandButton1¡÷CommandButton2¡÷CommandButton3¥¨¶°µ{¦¡¡H(¦b¤£¨Ï¥Î¨ì¼Ò²Õªº±¡ªp¤U)
°w¹ï²Ä¤@­Ó°ÝÃD¬O«ü¦A¦P¤@­ÓÀɮפº
¦ý¦pªG¦A¤£¦PÀɮ׮ɭn¦p¦ó³]©w©O

TOP

oobird ¦Ñ®v
§Ú¬O«ü¤w¸g¥Î¥¨¶°(excelÀÉ®×B)¨Ó¶}±Ò¤@­ÓexcelÀÉ®×A
¦ý­n
¦p¦ó¥ÎexcelÀÉ®×B¤¤ªºcommandButton1
¥h°õ¦æexcelÀÉ®×A¤¤ªºcommandButton1

TOP

Private Sub CommandButton1_Click()
Application.Calculation = xlCalculationManual '¤â°Ê­pºâ
Workbooks.Open Filename:="C:\Documents and Settings\k1489.KT_DOMAIN\®à­±\§õÂí¦¿\02_§Þ®v«O¥À\02_§Þ®v«O¥À¦¨®Ä_µ{¦¡.xls"  '¶}ÀÉ
Run "02_§Þ®v«O¥À¦¨®Ä_µ{¦¡.xls!Sheets(µ{¦¡).CommandButton7_Click"
ActiveWorkbook.PrecisionAsDisplayed = False
ActiveSheet.Calculate
End Sub

¦n¹³¤£¦æ­C

TOP

oobird¦Ñ®v
¥Î³o¼Ë¥h¶]·|¥X²{"°}¦C¯Á¤Þ¶W¥X½d³ò"

TOP

¬O«üshee1(µ{¦¡)
Workbooks("02_§Þ®v«O¥À¦¨®Ä_µ{¦¡.xls").Sheet1.CommandButton7_Click

TOP

©êºp~~­è­è¶Ç¿ù¤F~~
§ï¦¨¦p¦¹«á´ú¸Õ¤w¥¿±`~~·P®¦
Run "02_§Þ®v«O¥À¦¨®Ä_µ{¦¡.xls!Sheet1.CommandButton7_Click"

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD