|
|
|
ÄÁÅÙÃ÷ | contents |
|
|
½ºÅ͵ð | study |
|
|
|
|
|
|
|
|
VBA¿¡¼ addin solver.xla »ç¿ë¹ýÀ» ¾Ë·ÁÁֽʽÿÀ. |
|
|
±Û¾´ÀÌ : ÀÌ»ó±Ô °íÀ¯ID : ÀÌ»ó±Ô
³¯Â¥ : 00-00-00 00:00
Á¶È¸ : 9720
|
|
|
¼ö°í°¡ ¸¹À¸½Ê´Ï´Ù.
2´Þ µ¿¾È ¸øÇ®Àº ¹®Á¦Àε¥ Àý½ÇÈ÷ ºÎŹÇÕ´Ï´Ù.
¿©·¯±ºµ¥ ¹®ÀǸ¦ Çغ¸¾ÒÁö¸¸, »ÇÁ·ÇÑ ÇعýÀ» ÁÖÁö ¾Ê´õ±º¿ä.
°øÇÐ ¹®Á¦¸¦ XLA·Î ¹®Á¦¸¦ Ç®·Á°í ÇÕ´Ï´Ù. À̶§, "ÇØã±â"°¡ »ç¿ëµÇ±â ¶«¿¡
÷ºÎµÈ fileÀÇ VBA code¸¦ »ç¿ëÇÏ¿´½À´Ï´Ù.
¾Æ½Ã´Ù½ÃÇÇ, addinÀÎ ÇØã±â¸¦ »ç¿ëÇÏ·Á¸é, ÀÏ´Ü ÇØã±â¸¦ VBA ȯ°æÀ¸·Î loadingÇÑ ÀÌÈÄ¿¡ ÇÔ¼ö¸¦ ºÒ·Á¾ß ÇÏÀݾƿä. Á¦°¡ ¸¹µç xla¸¦ loadingÇÏ°í ±× program¿¡¼ VBA codeÀÇ OpenSolverXla() ¸¦ ½ÇÇàÇϸé,
"ÇØã±â: ¿¹»óÇÏÁö ¾Ê¾Ò´ø Áß°£ ¿À·ù°¡ ¹ß»ýÇ߰ųª »ç¿ë °¡´ÉÇÑ ¸Þ¸ð¸®°¡ ¾ø½À´Ï´Ù" °¡ ³ª¿É´Ï´Ù. (Error À§Ä¡´Â Call Application.Run("solver.xla!SolverOptions",.... ºÎºÐÀÔ´Ï´Ù)
±×·±µ¥, Excel ȯ°æÀÇ "µµ±¸" -> "ÇØã±â"¸¦ Çѹø ½ÇÇàÇÏ°í, À§ÀÇ ÇÔ¼ö¸¦ ½ÇÇàÇϸé Error°¡ ¾ø½À´Ï´Ù.
Error ¾øÀÌ "ÇØã±â"¸¦ LoadingÇÏ´Â ¹æ¹ýÀÌ ¾øÀ» ±î¿ä?
VBEȯ°æ¿¡ µµ±¸->ÂüÁ¶µµ »ç¿ëÇØ ºÃÁö¸¸, °°Àº Error°¡ ³ª¿À°í ÀÖ½À´Ï´Ù.
Á¦ °³ÀÎÀûÀÎ »ý°¢À¸·Î´Â "ÇØã±â" ÇÔ¼öÀÇ »ç¿ë¿¡ ÀÏÁ¤ÇÑ ¼ø¼°¡ ÀÖÀ» °Í °°±âµµ ÇÏ°í, ¾Æ´Ô, ÇѱÛÆÇ VBA addin ÀÚü Error°¡ ¾Æ´Ñ°¡ ÇÏ´Â »ý°¢µµ ÇØ º¸¾Ò½À´Ï´Ù.
Âü°í·Î »ç¿ëÇÑ ÇÔ¼öÀÇ List¿Í ProgramÀ» ¼ÛºÎÇÕ´Ï´Ù.
Function OpenSolverXla() As Boolean
Dim AddinItem As AddIn
Dim temp As String
On Error Resume Next
temp = Workbooks("Solver.xla").Name
If Err = 0 Then
OpenSolverXla = True
Application.Run "solver.xla!SolverReset"
Call Application.Run("solver.xla!SolverOptions", 100, 100, 0.000001, False, False, 1, 1, 1, 5, True, 0.0001, True)
Exit Function
End If
For Each AddinItem In AddIns
If AddinItem.Name = "SOLVER.XLA" Then
Workbooks.Open AddinItem.FullName
Application.Run "solver.xla!SolverReset"
Call Application.Run("solver.xla!SolverOptions", 100, 100, 0.000001, False, False, 1, 1, 1, 4, True, 0.0001, True)
OpenSolverXla = True
Exit Function
End If
Next
OpenSolverXla = False
MsgBox "Addin £§Solver.xla£§°¡ Install µÇÁö ¾Ê¾Ò½À´Ï´Ù." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _
"£§µµ±¸£§->£§Ãß°¡±â´É...£§¿¡¼ £§ÇØ Ã£±â Ãß°¡ ±â´É£§À» ¼±ÅÃÇØ ÁֽʽÿÀ£§" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _
"ȤÀº Excel Program Install ½Ã¿¡ ´©¶ôµÇ¾úÀ» ¼öµµ ÀÖ½À´Ï´Ù."
End Function
|
|
|
|