여기저기 관련글 스크랩 Using useless Select, Activate, ActiveCellUsing Select, Activate and ActiveCell in VBA can bring problems. And shows problems. In general, if you use the macro-recorder and record a macro, then you would see lots of Select, Activate, ActiveCell and etc. And it would work. Then why is it a problem?It is slow. All these .Activate and .Select actions take time.It is not necessa..
CoolProp.dll을 활용할 수 있는 Nuget이 있어서 검색하니 2가지 정도가 나온다(2022.01) -하나는 SharpFluids이고 (https://github.com/MadsKirkFoged/SharpFluids)-다른 것은 SharpProp이다. (https://github.com/portyanikhin/SharpProp) 둘의 기능은 크게 차이가 없고 -build-를 보면 둘다 CoolProp.dll을 사용하는 것은 동일하지만 unit convert를 해주는 기능이 SharpFluids가 조금 더 편리한 듯 하다. SharpFluids를 보면 .Net 472~ .Net 5와 NetCore까지 활용할 수 있고 CoolProp에서 사용하는 enum (List)들도 상대적으로 Shar..
ERRORUnhandled exception. System.DllNotFoundException: https://docs.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170 _
Error NumberDefault Error Message5Procedure call or argument is not valid6Overflow7Out of memory11Division by zero51Internal error52Bad file name or number53File not found55File already open76Path not found482Printer error On Error Resume Next"Statement" If Err.Number 0 Then " statements" ''''''''''''''''''''' Imports SystemPubl..