[vb.net] DateTimePicker 전월, 전주, 어제, 오늘, 금주 설정하기
Private Sub cmd_d_x_Click(sender As Object, e As EventArgs) Handles cmd_d_5.Click, cmd_d_4.Click, cmd_d_3.Click, cmd_d_2.Click, cmd_d_1.Click Dim nm As String = sender.Name Dim idx As Integer = nm.Split("_").Last Select Case idx Case 1 '// 전월 DTP_0_1.Value = DateSerial(Year(Now), Month(Now) - 1, 1) DTP_0_2.Value = DateSerial(Year(Now), Month(Now), 0) Case 2 '// 전주 DTP_0_2.Value = Now.Date.AddDay..
2023. 5. 22.
[vb6.0/vba] 파일명에서 사용할 수 없는 텍스트(파일명) 치환함수
Function changeFileName(txt) s = txt s = Replace(s, "\", "_") s = Replace(s, "/", "_") s = Replace(s, ":", "_") s = Replace(s, "*", "_") s = Replace(s, "?", "_") s = Replace(s, """", "_") s = Replace(s, "", "_") s = Replace(s, "|", "_") changeFileName = s End Function
2023. 3. 11.
[vb.net] csv 내보내기(Export data to CSV file in VB.NET)
AddHandler ts.Click, Sub(so As ToolStripMenuItem, ea As EventArgs) Dim tem As String = "급여일,사원번호,이름,부서,직책,기본급,식대,자가운전,성과급,지급액계,국민연금,건강보험,고용보험,장기요양보험,소득세,지방소득세,공제액계,차인지급액2023-03-31,202301011,홍길동,인사팀,과장,1500000,100000,0,0,1600000,100000,110000,12000,4500,3200,2500,232200,1367800" Dim fileName As String = Path.Combine(APP_USER_DATA_PATH, "salary_example.csv") My.Computer.FileSystem.WriteAllText(fil..
2023. 2. 25.