[VBA]파일 다운로드 하기

Function DownloadFromURL(FileUrl As String, NewFullName As String) Dim oXMLHTTP As Object, oStream As Object On Error GoTo ERROR_EXIT Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP") oXMLHTTP.Open "GET", FileUrl, False oXMLHTTP.send If oXMLHTTP.Status = 200 Then Set oStream = CreateObject("ADODB.Stream") oStream.Open oStream.Type = 1 oStream.Write oXMLHTTP.responseBody oStream.SaveToFile NewFullNam..

아두이노 드론 모터 제어 테스트

const int MOTOR_A = 23; const int MOTOR_B = 19; const int MOTOR_C = 18; const int MOTOR_D = 26; const int CHANNEL_A = 1; const int CHANNEL_B = 2; const int CHANNEL_C = 3; const int CHANNEL_D = 4; const int MOTOR_FREQ = 5000; const int MOTOR_RESOLUTION = 10; int selectedMotor = 0; int previousMotor = 0; void setup() { ledcSetupChannels(); ledcAttachPins(); ledcWriteChannels(0); Serial.begin(11520..

code128 font

=SUBSTITUTE(code128(A2),"Â"," ")

code39 font

엑셀 & VBA - 서식 삭제하기

Range("A1:A15").ClearFormats

C# chart 데이터 가져오기 연습

private void chart1_MouseClick(object sender, MouseEventArgs e) { HitTestResult result = chart1.HitTest(e.X, e.Y); if (result.ChartElementType == ChartElementType.DataPoint && result.PointIndex != -1) { Log(result.PointIndex.ToString()); } }