Skip to content

Instantly share code, notes, and snippets.

View MeatKeenEachRow's full-sized avatar

310ken MeatKeenEachRow

  • japan
View GitHub Profile
@MeatKeenEachRow
MeatKeenEachRow / gist:f30e3d1c3d22ed9e8c378c16f35c3849
Created June 19, 2025 13:07
C# パケットキャプチャ ソケットを `ProtocolType.IP` & `SocketType.Raw` で生成。 - `IOControlCode.ReceiveAll` を使って全パケット受信設定
using System;
using System.IO;
using System.Net;
using System.Net.Sockets;
using System.Text;
class Program
{
static void Main()
{
@MeatKeenEachRow
MeatKeenEachRow / Sheet.vba
Created June 18, 2025 23:22
Excel VBA Diffツール シート ダブルクリックイベント
Option Explicit
' A列をダブルクリックでVisualDiffToSheetを呼び出す
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 _
And Me.Cells(Target.Row, 2).Value = "File" Then
Dim f1 As String, f2 As String
f1 = Me.Cells(Target.Row, "I").Value
@MeatKeenEachRow
MeatKeenEachRow / gist:58518454b5a670d93a2a8aa508808b67
Created June 18, 2025 15:06
Excel Diff ツール シートモジュール(シートのマクロとして貼り付ける)
Option Explicit
' A列をダブルクリックでVisualDiffToSheetを呼び出す
Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 _
And Me.Cells(Target.Row, 2).Value = "File" Then
Dim f1 As String, f2 As String
f1 = Me.Cells(Target.Row, "I").Value
@MeatKeenEachRow
MeatKeenEachRow / Module1.vba
Last active June 18, 2025 23:19
Excel VBA Diffツール モジュール
Option Explicit
'------------------------------------------------
'■ メイン:B2/B3のパスを読み込み、ツリー比較を行う
Sub CompareFolders()
Dim folder1 As String, folder2 As String
Dim fso As Object, ws As Worksheet
Dim outRow As Long
Set ws = ThisWorkbook.ActiveSheet